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

152 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
enhance123969(None) 
enhanced1436621enhanced
enhancer1346681enhancer
enhances1339291enhances
bechance1747742bechance
chance134617092_chance
enface112510352enfa_ce
enhancers1445102enhancers
enhancive1752692enhancive
enlace82213232enla_ce
enounce937572enounce
entrance10311332entrance
ethane94613242ethan_e
hance105424152__hance
nance74721842_n_ance
nuance859042_nuance
penance11313442pen_ance
tendance1147522tendance
advance1346043advance
ananke1038283an_anke
andante8311273andante
anlace82513923anla_ce
askance1345923askance
balance11510263balance
bechanced1945643bechanced
bechances1847613bechances
chanced154113213_chanced
chancel144011773_chancel
chancer144215633_chancer
chances145218093_chances
chancre14348783_chancre
chancy164010863_chancy
change124116753_change
dance85223133__dance
defiance1477633defiance
denounce1145103denounce
deviance1477083deviance
durance1059113durance
efface14366673effa_ce
elegance1146373elegance
enable83318483en_able
enact73525363en_a_ct
enate54428153en_a_te
encage93713503enca_ge
encase83714363enca_se
enchant12313123enchan_t
enchanted1546553enchanted
enchanter1446193enchanter
enchants1347833enchants
enchase1239463encha_se
endanger1045853endanger
endarch1345443endarch
endurance1245243endurance
enfaced13218913enfa_ced
enfaces122110913enfa_ces
enforce12237423enforce
engage82812103enga_ge
engine71114863engin_e
enhalo987563enha_lo
enhaloed12125933enhaloed
enhaloes1197343enhaloes
enhalos1087533enhalos
enhancing1545823enhancing
enlaced102410523enla_ced
enlaces92313393enla_ces
enlarge835533enlarge
enounced1135883enounced
enounces1037603enounces
enplane939723enplan_e
enrage72715073enra_ge
ensconce1244713ensconce
ensnare767123ensnare
entangle966253entangle
entente7412953entente
entice81316863en_tice
entranced1247393entranced
entrances11310953entrances
errancy1256363errancy
essence947673essence
ethanes103713513ethanes
ethanol1044593ethanol
ethene93312923ethen_e
ethyne12407153ethyn_e
evince1137763e_vince
exchange21124323exchange
exhale1636873exha_le
expanse16145603expanse
feasance1345823feasance
fiance11310743_fiance
finance1238573finance
glance94312313_glance
hances115621283__hances
hanse85722793__hanse
henbane1237353henban_e
hence104920043__hence
inane52820343in_an_e
infancy1546173infancy
infante101910883infante
inhale9411513inha_le
inlace82513043inla_ce
insane6314893insan_e
instance1049883instance
joyance1944773joyance
lance75126723__lance
lenience1048333lenience
menace103216943men_a_ce
methane123211793methan_e
nances83618643_n_ances
nancy105214923_n_ancy
nonce75719823_n_once
nondance1148243nondance
nuanced1036203_nuanced
nuances938523_nuances
penanced1338163pen_anced
penances12312443pen_ances
pentane9415743pentan_e
perchance1866393perchance
prance104318573_prance
rance75028513__rance
rechange1458183rechange
reliance10310473reliance
renounce1047403renounce
romance11311083romance
seance83716693_seance
sentence1099863sentence
sonance9310313sonance
stance84316913_stance
tenace82715693ten_a_ce
tenancy1237503ten_ancy
tendances1247573tendances
tendence1148523tendence
tenpence1246403tenpence
thane86122533_than_e
thence112010843_thence
trance84718763_trance
unchancy1844703unchancy
unfancy1545203unfancy
unfence1239193unfence
unhand10410383unhan_d
unhanded132910183unhanded
unhands1137773unhands
unhandy1445513unhandy
unhang1038443unhan_g
unhanged13258833unhanged
unhangs1136203unhangs
unhinge11237283unhinge
unlace82215173unla_ce
usance858013_usance
valance1269253valance
vendace1357363venda_ce
vengeance1543853vengeance
whence14187923_whence

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.653273646.2
2DLD Change Limit1340271526.73619897.1
3Display Results1521520.0463304.3
 (SQL Overall)1786911527.43524033.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.