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

110 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
enframe124736(None) 
enflame1236571enflame
enframed1466261enframed
enframes1357451enframes
bedframe1643022bedframe
endgame1145232endgame
enface112510352enf_ace
enflamed1455722enflamed
enflames1357042enflames
engram9310652engram_
engramme1344052engramme
engrams1038072engrams
engrave1137132engrave
enrage72715072en_rage
frame105821802__frame
inflame1256962inflame
reframe1239392reframe
unframed1478242unframed
aflame1138723_aflame
airframe1344293airframe
arame75026623__arame
bedframes1743013bedframes
bename103316073ben__ame
defame123212433def_ame
efface14366673e_fface
embrace1388893embrace
emirate91015833emirate
enamel81210113en__amel
enate54428143en__ate
encage93713503en_cage
encamp1235943en_camp
encase83714363en_case
enchase1239453enchase
enclave1257533enclave
endgames1245423endgames
enervate1148453enervate
enfaced13218913enf_aced
enfaces122110913enf_aces
enfilade1243743enfilade
enforce12237423enforce
enframing1546113enframing
engage82812103en_gage
engraft11118613engraft
engrail846263engrail
engrain838353engrain
engrammes1444513engrammes
engraved1335813engraved
engraver1245333engraver
engraves1237233engraves
enlace82213233en_lace
enlarge835533enlarge
enolase7310193enolase
enorm74415633enor_m_
enplane939723enplane
enraged93511783en_raged
enrages83114853en_rages
enrapt8313013en_rapt
enrobe86610793en_robe
enslave1036273enslave
ensnare767123ensnare
entrain7313073entrain
entrance10311323entrance
entrant7318873entrant
entrap8710563entra_p
entraps9109763entraps
entree61817883entr_ee
enure53520223enur__e
enwrap1185213enwra_p
enwraps1284833enwraps
enzyme2054343en_zyme
erase54925493e__rase
extreme1645653extreme
fame95639393__f_ame
flame105124443__flame
frae75330473__fra_e
framed125116523__framed
framer114817443__framer
frames115119863__frames
gendarme1243523gendarme
generate9312903generate
infamy1435653inf_amy
infare9313083inf_are
inflamed1446033inflamed
inflamer1356123inflamer
inflames1377323inflames
inflate10312313inflate
infra838643infra__
infract12610003infract
infrared1236193infrared
ingrate8715123ingrate
macrame1338713macrame
mainframe1642063mainframe
misframe1546973misframe
name65637413_n__ame
offramp1742153offramp
penname11328553pen_name
reframed1437853reframed
reframes1338993reframes
reinflame14133883reinflame
rename82718813ren__ame
selfsame1342883selfsame
subframe1546333subframe
unbrace111910483unbrace
unbrake13239123unbrake
uncrate9415953uncrate
undrape1049333undrape
unfree9413203unfr_ee
unfroze1945413unfroze
untame82513603un_tame
venerate11312903venerate

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.1401276364.3
2DLD Change Limit1340271107.39018136.3
3Display Results1101100.0333333.3
 (SQL Overall)1786911107.56323627.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.