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

135 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
enlisting103834(None) 
delisting112710502delisting
encysting1544612encysting
enditing10311072endi_ting
englishing1543872englishing
enisling949632en_isling
entwisting1443852entwisting
existing1639072e_xisting
insisting1038822insisting
listing84020592__listing
reenlisting1244672reenlisting
relisting102414352relisting
agisting1038243_agisting
anointing1038623anointing
assisting1046183assisting
bemisting1438073bemisting
blasting114013433_blasting
blissing1136873_blissing
colistin10410553colistin_
colistins1149223colistins
consisting1349523consisting
desisting112810383desisting
easting84924303e__asting
eclipsing1443743eclipsing
editing9313133e_di_ting
egesting1039013e_gesting
elastin72611843e_lastin_
elastins82111743e_lastins
elating83423083e_l_ating
electing112113783e_lecting
eliciting1237773e_liciting
eliding93414343e_li_ding
eluting84115293e_l_uting
emitting112410353e_mitting
enacting11311363en_acting
encashing1536443encashing
encasing11610823encas_ing
enclasping1544103enclasping
enclosing1257573enclos_ing
encrusting13125293encrusting
engilding1244483engilding
engining1039293engi_ning
engirding1244153engirding
englutting1242723englutting
enlacing1148773enl_acing
enlarging1135803enlarging
enlist6417043enlist___
enlisted978193enlist_ed
enlistee868323enlist_ee
enlistees954583enlistees
enlister847803enlist_er
enlisters937113enlisters
enlistment1246853enlistment
enlists749393enlist__s
enlivening1442933enlivening
enmeshing15114873enmeshing
enriching1546153enriching
enrooting10128133enrooting
ensiling9410723ensi_ling
ensuing8239543en__suing
enticing11311803enti_cing
entitling1037103entitling
entrusting11126183entrusting
envisaging1542043envisaging
enwinding1444933enwinding
epilating12310973epilating
evicting1437483e_victing
eviting11511373e_vi_ting
excising1837213excis_ing
exciting1838023exci_ting
exiting15311393e_xi_ting
expiating1938543expiating
filiating1339253filiating
fisting113818123__fisting
flinting123412343_flinting
flirting12319013_flirting
fliting113514613_fli_ting
flitting123010883_flitting
foisting122910503_foisting
foliating1339253foliating
glinting103210053_glinting
heisting123411043_heisting
histing113720373__histing
hoisting123610903_hoisting
incising11411093incis_ing
inciting11312533inci_ting
indicting1339613indicting
inditing10312113indi_ting
infesting13109513infesting
inflicting1645723inflicting
ingesting11129623ingesting
inletting1087873inletting
intwisting1445063intwisting
investing13119393investing
inviting1239733invi_ting
joisting16328503_joisting
knitting13257023kn_itting
lasting84725243__lasting
leniting9312353len_i_ting
lifting113313273__lifting
lilting83515383__lilting
linting83820983__linting
lisping103412753__lisping
listings93310043__listings
lusting83619323__lusting
misting103623383__misting
molesting1237753molesting
nesting84320443_n_esting
noising83615173_nois_ing
penalising1347623penalis_ing
persisting1346653persisting
polishing1536923polishing
realising10313173realis_ing
relishing13229183relishing
renesting102514703ren_esting
resisting103215313resisting
retwisting1445633retwisting
sealifting1444633sealifting
slitting93012583_slitting
splinting1238193splinting
splitting1236563splitting
twisting12427813_twisting
unfitting1336423unfitting
uniting8315823un_i_ting
unlashing1336493unlashing
unlinking1436273unlinking
unliving1248193unli_ving
unresting10311133unresting
untwisting1443943untwisting
unwishing1635593unwishing
unwitting1335583unwitting
uplifting1534963uplifting
waisting123615213_waisting
whisting15329543_whisting
wisting113519743__wisting

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411357.23620541.9
3Display Results1351350.0602250.0
 (SQL Overall)1786911357.71623158.5
 
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.