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

111 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
enframes135745(None) 
enflames1357041enflames
enframe1247361enframe_
enframed1466261enframed
bedframes1743012bedframes
endgames1245422endgames
enfaces122110912enf_aces
enflame1236572enflame_
enflamed1455722enflamed
engrammes1444512engrammes
engrams1038072engram_s
engraves1237232engraves
enrages83114852en_rages
frames115119862__frames
inflames1377322inflames
reframes1338992reframes
unframed1478242unframed
airframes1443663airframes
arames84622573__arames
bedframe1643023bedframe_
benames112814603ben__ames
defames132812253def_ames
effaces15277273e_ffaces
embraces14128873embraces
emirates101214853emirates
enamel81210113en__amel
enamels9128163en__amels
enates64026433en__ates
encages103313783en_cages
encamps1335423en_camps
encases93116053en_cases
enchases13310273enchases
enclaves1357703enclaves
endgame1145233endgame_
energies9310783energies
enervates1248723enervates
enface112510353enf_ace_
enfaced13218913enf_aced
enfilades1343883enfilades
enforces13208013enforces
enframing1546113enframing
engages92912493en_gages
engrafts1294703engrafts
engrails945383engrails
engrains937583engrains
engram9310653engram__
engramme1344053engramme
engrave1137133engrave_
engraved1335813engraved
engraver1245333engraver
engravers1344313engravers
enlaces92313393en_laces
enlarges946073enlarges
enolases8411013enolases
enplanes1039483enplanes
enrage72715073en_rage_
enraged93511783en_raged
enrobes92211113en_robes
enslaves1136393enslaves
ensnares856893ensnares
entases72816273en_tases
entrails8310163entrails
entrains8312963entrains
entrances11310953entrances
entrants8311753entrants
entraps9109763entra_ps
entrees71813773entr_ees
entremets1147143entremets
entries71523163entr_ies
enures63919713enur__es
enureses838113enureses
enwraps1284833enwra_ps
enzymes2164413en_zymes
erases64425403e__rases
extremes1756053extremes
fames105735923__f_ames
flames114723693__flames
frame105821803__frame_
framed125116523__framed
framer114817443__framer
framers125113823__framers
gendarmes1343923gendarmes
generates10312713generates
infamies1346683inf_amies
infares10313023inf_ares
inflame1256963inflame_
inflamed1446033inflamed
inflamer1356123inflamer
inflamers1455213inflamers
inflates11512193inflates
infracts1346623infracts
infrared1236193infrared
infrareds1342583infrareds
ingrates9514173ingrates
macrames1438953macrames
mainframes1752333mainframes
misframes1646633misframes
names74833363_n__ames
offramps1841653offramps
pennames12287793pen_names
reframe1239393reframe_
reframed1437853reframed
reinflames15154013reinflames
renames92418053ren__ames
subframes1645853subframes
unbraces12229413unbraces
unbrakes14258413unbrakes
uncrates10314563uncrates
undrapes1138603undrapes
unfrees1048643unfr_ees
venerates12312263venerates

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621117.36019859.0
3Display Results1111110.0502220.0
 (SQL Overall)1786911117.83022821.3
 
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.