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 “dislodges” 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.

44 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
dislodges124516(None) 
dislodge1145171dislodge_
dislodged1344571dislodged
mislodges1344361mislodges
disgorges1245852disgorges
displodes1347862displod_es
mislodge1244112mislodge_
mislodged1443842mislodged
diallages1145463diallages
dialoged1146693dialo_ged
dialoger1056083dialo_ger
dialogers1155163dialo_gers
dialogs938103dialo_g_s
dialogues1144813dialogues
dildoes9229243di_l_does
diodes83915783di__od_es
diploes101111493diplo__es
diploidies1463833diploidies
diploses111110323diplo_ses
dipodies1238413di_podies
discloses1249473disclo_ses
disgorge1145733disgorge_
disgorged1345263disgorged
dislikes132810843disl_ikes
dislocates13108323dislocates
dislodging1444403dislodging
dislodgment1693723dislodgment
dislodgments1783213dislodgments
displode1247643displod_e_
disploded1446543displod_ed
disposes11313823dispo_ses
disrobes1139743disro_bes
dissolves1346233dissolves
distomes11314163disto_mes
disyokes1656503disyo_kes
dodges96119083d___odges
lodges86820153___lodges
miscodes13310423miscod_es
misjudges2042643misjudges
pishoges1446953pisho_ges
sledges94511573__sledges
sludges93811993__sludges
splodges1234153_splodges
stodges9309083__stodges

Search took 9 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 Filter1786911486410.423422437.4
2DLD Change Limit148641447.92018767.8
3Display Results44440.0162750.0
 (SQL Overall)178691448.35921377.1
 
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.