Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “pignolis” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

63 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
pignolis114605(None) 
pignoli1045441pignoli_
pignolia1144381pignolia
pignolias1243721pignolias
pinoles93418702pi_noles
aiolis6316843ai__olis
bignonia1144233bignonia
bignonias1243783bignonias
cannolis1037863cannolis
diagnosis1144823diagnosis
finalis103313663fi_nalis
gigolos934693gig_olos
gingelis10247093gingelis
gingilis10255593gingilis
gnosis75711213__gnosis
ignores8269003_ignores
magnolia1144793magnolia
magnolias1244723magnolias
mignons1037863migno_ns
pangolin1147773pangolin
pangolins1247373pangolins
peignoir1142873peigno_ir
peignoirs1242393peignoirs
phenolic1546813phenolic
phenolics1645053phenolics
phenols1238103phenol_s
pianos84315933piano__s
piccolos1444133piccolos
picolin11310883pi_colin
picolins1239853pi_colins
pieholes13168913pieholes
pigboats1344523pigboats
pigeons1039183pigeo_ns
pignora10306363pigno_ra
pignus937953pign__us
pignuts1035613pign_uts
pigouts1037593pig_outs
pigtails1146033pigtails
pilis75825203pi___lis
pinfolds1445143pinfolds
pingoes105116523pingo_es
pingos95317673pingo__s
pinholes131810663pinholes
pinnules1036463pinnules
pinocles1248693pi_nocles
pinole83218783pi_nol_e
pinones94717073pi_nones
pinons86019943pi_no_ns
pinots85920273pi_no_ts
pintles94118723pi_ntles
pistoles102514723pistoles
pistols93213983pistol_s
polis74731163p___olis
prognosis1246723prognosis
propolis12311403propolis
pycnosis1554733pycnosis
pyknosis1753643pyknosis
signalise1046393signalise
signals8359163signal_s
signoras9306553signoras
signori8347893signori_
signories10107853signories
signors83410913signo_rs

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.420425454.8
2DLD Change Limit146162636.31323152.5
3Display Results63630.0461369.6
 (SQL Overall)178691636.77926359.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.