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

100 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
enfetter114535(None) 
enfetters1244461enfetters
unfetter1136751unfetter
effecter1664772effecter
enfettered1442482enfettered
enfever1344642enfe_ver
fetter94120382__fetter
infecter13229152infecter
infester11239432infester
insetter8218592insetter
netter63722022_n_etter
unfetters1244362unfetters
abetter958323_abetter
affecter1644523affecter
anteater8311603anteater
bedwetter1542663bedwetter
beefeater1443603beefeater
begetter11136313begetter
benefiter1443733benefiter
besetter10137973besetter
better84723703__better
defeater122611663defeater
effected1744993effected
effecters1764323effecters
effector1644873effector
effete1235183effe_te_
embitter12245623embitter
emitter93211083e_mitter
enfeebler14172133enfeebler
enfettering1543233enfettering
enfevers1444513enfe_vers
enfolder1286153enfolder
enforcer13246503enforcer
engender1046633engender
enlister847803enlister
entente7412953entente_
ententes8312773ententes
enter54726383en___ter
enterer72015633ente_rer
erecter93113393e_recter
expecter1936513expecter
fatter94523213__fatter
feater95224053__feater
fester94723513__fester
fetted104817893__fetted
fetters103517903__fetters
fitter94120033__fitter
fretter103412753_fretter
genette838863gen_ette_
genettes938303gen_ettes
getter74117613__getter
incenter102212093incenter
indenter92311443indenter
infected14229403infected
infecters14257583infecters
infector13478853infector
inferrer11217443inferrer
infested12249643infested
infesters12237713infesters
inflater1149893inflater
inputter1034203inputter
inserter82312133inserter
insetted9249023insetted
insetters9187133insetters
inventer112410843inventer
inverter112411073inverter
knitter11348133kn_itter
knotter11317643kn_otter
letter63722583__letter
mofette1296773mofette_
mofettes1386083mofettes
natter64420743_n_atter
neater64424313_n_eater
nester64124183_n_ester
nether94014163_n_ether
netted74118713_n_etted
netters73618583_n_etters
nettier74211813_n_ettier
nettler7349503_n_ettler
neuter63713793_n_euter
nutter63918053_n_utter
perfecter1646043perfecter
petter83924773__petter
pinsetter1145013pinsetter
regretter1045973regretter
reletter81311023reletter
resetter81511833resetter
setter64023723__setter
tetter64322453__tetter
unbitter1046173unbitter
unfelted1279403unfelted
unfettered1443653unfettered
unfitted1238163unfitted
unletted9310313unletted
untether1145163untether
unwetted1238123unwetted
upsetter1034643upsetter
vetter93417643__vetter
wetter93919443__wetter
whetter13348803_whetter

Search took 9 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.1561145455.1
2DLD Change Limit1461621008.03018202.0
3Display Results1001000.0502000.0
 (SQL Overall)1786911008.23621696.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.