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

138 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
wildering145674(None) 
bewildering1872702bewildering
cindering13311222cindering
filtering13199722filtering
hindering14310272hindering
mildening1345672mildening
mildewing1643732mildewing
moldering1367862moldering
niddering1255322niddering
nidering10510482ni_dering
pilfering1536392pilfering
silvering1337922silvering
soldering1169032soldering
tillering1037882tillering
wandering143310982wandering
weltering13219492weltering
widening13237832wi_dening
wilding123814292wild__ing
wildling13248082wild_ling
wintering13412362wintering
withering16108812withering
wondering142110462wondering
altering91917113_altering
bickering1837663bickering
billeting1236633billeting
bittering122511993bittering
bordering1338833bordering
bouldering1464763bouldering
ciphering17217703ciphering
dandering122511063dandering
diademing1454323diademing
diapering1339033diapering
dickering1737463dickering
differing1746473differing
dithering1499853dithering
doddering1335183doddering
faltering132211113faltering
fileting1239303fil_eting
filleting1335843filleting
fingering1439193fingering
fleering123811283_fleering
foddering1535163foddering
fullering1336653fullering
gandering122111293gandering
gendering12249753gendering
gibbering1534713gibbering
gilding103813003gild__ing
gingering1238873gingering
haltering132212003haltering
hilding123713533hild__ing
hollering1337743hollering
indexing1737123_indexing
inhering12913713_inhering
jiggering1934303jiggering
jittering17218423jittering
juddering1933763juddering
kilderkin1351653kilderkin_
kilderkins1451833kilderkins
kippering18205443kippering
laddering1237593laddering
leering83417643__leering
limbering1488793limbering
lingering11310513lingering
lippering14217883lippering
littering102411983littering
livering122012383li_vering
milding113615453mild__ing
mitering113015403mi_tering
mouldering1474283mouldering
murdering1357133murdering
nickering1636573nickering
nidderings1362733nidderings
niderings1175403ni_derings
niffering1645133niffering
ordering1039353_ordering
paltering122612893paltering
pandering133211963pandering
peltering122011673peltering
philtering1646253philtering
pillaring1237643pillaring
pondering132411333pondering
powdering16246503powdering
rendering112213183rendering
sideling101012183si_deling
silverings1443843silverings
simmering1467823simmering
simpering1449293simpering
sintering101014803sintering
sistering101213753sistering
slivering1338083slivering
smoldering1474103smoldering
soldiering1244243soldiering
sundering11312323sundering
sweltering1445233sweltering
swithering17105213swithering
teddering12256303teddering
telfering1336253telfering
tendering112210813tendering
tiering8315253ti__ering
timbering14117723timbering
tinkering1437703tinkering
tittering102310313tittering
twittering1444583twittering
ulcering1139333_ulcering
wafering15208893w_afering
wagering13219523w_agering
waitering13310713waitering
wanderings15215833wanderings
watering122316313w_atering
wavering152410543w_avering
wedeling1338773w_edeling
welding123213253weld__ing
westering132112643westering
whickering2343413whickering
whimpering2143853whimpering
whispering1944343whispering
widdling14228743wi_ddling
widowing1635183wi_dowing
wielding13286863wield__ing
wilder103616473wilder___
wildered1336633wilder_ed
wilderment1653703wilderment
wilders113513503wilder__s
wildings13287933wild__ings
wildlings14244923wild_lings
wiling103024293wil___ing
willing113821613wil__ling
willowing1645323willowing
willying15306713wil_lying
wilting113515913wil__ting
winding123517913wind__ing
windling132212263wind_ling
windowing1744813windowing
wiring104521023wi___ring
wizening21255463wi_zening
wolverine1554343wolverine
wuthering1697803wuthering
zippering23215203zippering

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 Limit1486411386.17324079.2
3Display Results1381380.0632190.5
 (SQL Overall)1786911386.65626846.6
 
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.