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

143 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
diapering133903(None) 
bediapering1763042bediapering
capering132414962_capering
daikering1536102daikering
diademing1454322diademing
dickering1737462dickering
differing1746472differing
dispersing1449302dispersing
dithering1499852dithering
kippering18205442kippering
lippering14217882lippering
papering132213312_papering
simpering1449292simpering
tapering112112502_tapering
zippering23215202zippering
beavering1538703beavering
bickering1837663bickering
bittering122511993bittering
bumpering1636593bumpering
catering112019903_catering
chaptering18107963chaptering
chippering2045163chippering
cindering13311223cindering
ciphering17217703ciphering
clavering1538373clavering
compering163414163compering
coopering142611323coopering
coppering162810893coppering
cratering12312653cratering
dackering1737383dackering
daggering13246113daggering
dampening1535463dampening
dandering122511063dandering
dangering12239303dangering
dapping133714793d_ap_ping
dappling1436843d_appling
daring84928683d_a__ring
davening13258873d_avening
deadening1277583deadening
deafening1476273deafening
deairing10311893dea_iring
deepening1335613deepening
deperming1537113d_eperming
dewatering1545773dewatering
dialing94318173dia__ling
dialling10310783dia_lling
dialoging1246313dialoging
dialysing1444483dialysing
dialyzing2344043dialyzing
diapausing1442873diapausing
diaper94513113diaper___
diapered1238003diaper_ed
diapers104713913diaper__s
diapiric1344373diapiri_c
dieing84018653di__e_ing
dieseling1146143dieseling
dieting93616833di__eting
dimpling14199023dimp_ling
dipping134014833di_p_ping
disappearing1863143disappearing
discerning1447863discerning
disparting1438933disparting
dispelling1447613dispelling
dispending1547923dispending
dispensing1448233dispensing
disporting1439823disporting
disposing1339933disposing
disputing1337763disputing
disserting121310853disserting
disserving15117013disserving
diverging15226693di_verging
diverting142410333di_verting
dizening19177143di_zening
doddering1335183doddering
dowering132510613d_owering
draperied1344983draperied
draperies1249193draperies
draping114213353drap__ing
filtering13199723filtering
fingering1439193fingering
gibbering1534713gibbering
gingering1238873gingering
hampering1738863hampering
havering152211053_havering
hindering14310273hindering
impeding1436563_impeding
inhering12913713_inhering
jiggering1934303jiggering
jittering17218423jittering
laagering1136833laagering
lagering102212313_lagering
lappering14258843lappering
layering122310353_layering
limbering1488793limbering
lingering11310513lingering
lippening14234943lippening
littering102411983littering
livering122012383li_vering
loppering14237283loppering
mitering113015403mi_tering
nickering1636573nickering
niddering1255323niddering
nidering10510483ni_dering
niffering1645133niffering
pampering1638383pampering
paupering1437273paupering
peppering1337083peppering
pilfering1536393pilfering
piperine122011833pi_perine
quavering2235953quavering
repapering1547043repapering
ripening1138573ri_pening
sabering112113743_sabering
scampering1745323scampering
scarpering1545413scarpering
silvering1337923silvering
simmering1467823simmering
sintering101014803sintering
sistering101213753sistering
skippering1943673skippering
slavering1338723slavering
supering11317683_supering
tabering112211423_tabering
tampering1438453tampering
tempering1438733tempering
tiering8315253ti__ering
tillering1037883tillering
timbering14117723timbering
tinkering1437703tinkering
tittering102310313tittering
trapesing1247263trapesing
vaporing1437653_vaporing
viperine13189713vi_perine
wafering15208893_wafering
wagering13219523_wagering
waitering13310713waitering
watering122316313_watering
wavering152410543_wavering
whimpering2143853whimpering
whispering1944343whispering
wildering1456743wildering
wintering13412363wintering
withering16108813withering

Search took 7 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 Limit1486411436.39323250.6
3Display Results1431430.0602383.3
 (SQL Overall)1786911436.87325999.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.