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

40 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
enfilade124374(None) 
enfiladed1442991enfiladed
enfilades1343881enfilades
defilade13124432defilade
enflame1236572enf_lame
ensilage944712ensilage
defiladed15143473defiladed
defilades14134073defilades
enchilada15131913enchilada
enclave1257533en_clave
endplate1147083endplate
enface112510353enf__ace
enfilading1543243enfilading
enflamed1455723enf_lamed
enflames1357043enf_lames
enfold10137613enfol_d_
enfolded1345433enfol_ded
enfolder1286153enfol_der
enfolds11136253enfol_ds
enframe1247363enf_rame
engild8107613engil_d_
engilded1143983engil_ded
engilds974863engil_ds
enlace82213233en__lace
enolase7310193en_olase
enplane939723en_plane
ensilaged1143363ensilaged
ensilages1044433ensilages
ensile62616473ensil__e
ensiled82611433ensiled_
enslave1036273en_slave
envisage1242653envisage
epilate9314283e_pilate
escalade1144383escalade
inflame1256963inf_lame
inflate10312313inf_late
unfilled1298383unfilled
unfilmed1495803unfilmed
unlade72714153un__lade
ventilate1248383ventilate

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.406440125.6
2DLD Change Limit146162406.29623215.1
3Display Results40400.0162500.0
 (SQL Overall)178691406.71826598.8
 
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.