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 “enflame” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
enflame123657(None) 
enflamed1455721enflamed
enflames1357041enflames
enframe1247361enframe
inflame1256961inflame
aflame1138722_aflame
enclave1257532enclave
endgame1145232endgame
enface112510352enf_ace
enfilade1243742enfilade
enframed1466262enframed
enframes1357452enframes
enlace82213232en_lace
enolase7310192enolase
enplane939722enplane
enslave1036272enslave
flame105124442__flame
inflamed1446032inflamed
inflamer1356122inflamer
inflames1377322inflames
inflate10312312inflate
reinflame14133882reinflame
anlace82513923an_lace
anlage72514233an_lage
bedframe1643023bedframe
bename103316073ben__ame
blame95625493__blame
conflate13311173conflate
defame123212433def_ame
deflate113613943deflate
efface14366673e_fface
elate55335883e__late
elflike1435133elflike
emblaze2045773emblaze
emplace1338263emplace
emplane11410013emplane
emulate9314123emulate
enamel81210113en__amel
enate54428153en__ate
encage93713503en_cage
encamp1235943en_camp
encase83714363en_case
enchase1239453enchase
enclasp1145843enclasp
enclaved1456343enclaved
enclaves1357703enclaves
enclose999993enclose
endgames1245423endgames
endplate1147083endplate
enfaced13218913enf_aced
enfaces122110913enf_aces
enfiladed1442993enfiladed
enfilades1343883enfilades
enflaming1545633enflaming
enforce12237423enforce
engage82812103en_gage
engram9310653engram_
engramme1344053engramme
engrams1038073engrams
engrave1137133engrave
enlaced102410523en_laced
enlaces92313393en_laces
enlarge835533en_large
enolases8411013enolases
enplaned1137483enplaned
enplanes1039483enplanes
enrage72715073en_rage
ensilage944713ensilage
enslaved1245063enslaved
enslaver1144713enslaver
enslaves1136393enslaves
ensnare767123ensnare
enzyme2054343en_zyme
epilate9314283epilate
euclase938933euclase
exclave1945193exclave
fame95639393__f_ame
flake125119973__flake
flam96333293__flam_
flambe13489153__flambe
flamed124618973__flamed
flamen115215993__flamen
flamer114919123__flamer
flames114723693__flames
flams105125013__flams
flamy135217473__flamy
flare84823633__flare
flume106021173__flume
frame105821803__frame
infamy1435653inf_amy
infare9313083inf_are
inflamers1455213inflamers
inflated12410863inflated
inflater1149893inflater
inflates11512193inflates
inlace82513043in_lace
inulase739413inulase
lame66849293___lame
name65637413_n__ame
penname11328553pen_name
preflame1545913preflame
reclame11411063reclame
reflate103516263reflate
reframe1239393reframe
reinflamed16133423reinflamed
reinflames15154013reinflames
reinflate12157403reinflate
rename82718813ren__ame
selfsame1342883selfsame
unblamed1337193unblamed
unclamp1344993unclamp
unflawed1536123unflawed
unframed1478243unframed
unlace82215173un_lace
unlade72714153un_lade
untame82513603un_tame

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271166.67020094.0
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.12225090.0
 
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.