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

170 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
wildered133663(None) 
bewildered1742292bewildered
cindered1239792cindered
filtered12259042filtered
hindered1339452hindered
mildened1235772mildened
mildewed1543762mildewed
moldered1237172moldered
pilfered1435852pilfered
silvered12237562silvered
soldered1038152soldered
tillered937442tillered
wandered132110792wandered
weltered12238432weltered
widened12328052wi_dened
wilded113714502wild__ed
wilder103616472wilder__
wilders113513502wilder_s
wintered122111572wintered
withered15169432withered
wondered13239942wondered
altered83215733_altered
bickered17108003bickered
billeted1137643billeted
bistered112913323bistered
bittered112711833bittered
bordered1248933bordered
bouldered1344483bouldered
ciphered1637053ciphered
dandered112110963dandered
diademed1344153diademed
diapered1238003diapered
dickered16117533dickered
differed1635523differed
dithered13189293dithered
doddered1234943doddered
faltered122810983faltered
fendered13258673fendered
fibered1337643fi_bered
fileted1159093fil_eted
filleted1236603filleted
filterer11258143filterer
fingered13128333fingered
fleered11309503_fleered
foddered1434553foddered
fullered1236383fullered
gandered112211173gandered
gendered11258873gendered
gibbered1444303gibbered
gilded94413223gild__ed
gilder84415533gilder__
gilders94212463gilder_s
gingered11127743gingered
haltered123112553haltered
hinderer1238273hinderer
hollered1237603hollered
indeed83913563_inde_ed
indexed16347363_indexed
inhered11313163_inhered
jiggered1834203jiggered
jittered16267223jittered
juddered1833583juddered
kindred13316953kind_red
kippered17255623kippered
laddered1136743laddered
leered73816223__leered
limbered13158123limbered
lingered10129643lingered
lippered13287953lippered
littered92511383littered
livered113111633li_vered
milded104416153mild__ed
milder93818453milder__
milleped1335173milleped
misdeed113211053misde_ed
mitered103213233mi_tered
mouldered1343753mouldered
murdered1236023murdered
nickered15117023nickered
niffered1544143niffered
oilseed835783oilse_ed
ordered9108533_ordered
paltered113012483paltered
pandered121812573pandered
peltered112510453peltered
philtered1545493philtered
pilferer1344923pilferer
pillared11228093pillared
pondered126411293pondered
powdered15256893powdered
rendered102512263rendered
silverer11216733silverer
simmered1336863simmered
simpered1338253simpered
sintered92213903sintered
sistered92612803sistered
slivered12218103slivered
smoldered1343793smoldered
solderer947183solderer
soldiered1143763soldiered
sundered10312153sundered
sweltered1344453sweltered
swithered16135463swithered
teddered11255183teddered
telfered1234883telfered
tendered102510603tendered
tiered73613973ti__ered
timbered13137383timbered
tinkered1387683tinkered
tittered9239493tittered
twittered1333813twittered
ulcered1037973_ulcered
wafered14288433w_afered
wagered12299333w_agered
waitered1238753waitered
walleyed1534153walleyed
wanderer122210123wanderer
watered113014953w_atered
wavered142910433w_avered
wedeled1237783w_edeled
welded114013383weld__ed
welder102914413welder__
welders113313413welder_s
westered122511863westered
whickered22114033whickered
whimpered20144023whimpered
whiskered20123393whiskered
whispered18144373whispered
widder112913973widder__
widders123512273widder_s
widdled133511233wi_ddled
widener11318693wi_dener
wider94826353wi_der__
widowed1534843wi_dowed
widowered1742753widowered
wielded12216683wield__ed
wielder11197673wielder__
wielders12196613wielder_s
wildcard1543643wildcard
wildering1456743wildering
wilderment1653703wilderment
wilderness1443513wilderness
wildest113311273wilde_st
wildfire1542803wildfire_
wildfires1642833wildfires
wildland1353843wildland
wildwood1643593wildwood
wiled95231553wil___ed
wilier93217073wilier__
willed104722453wil__led
willer94021063willer__
willers103517913willer_s
willied114611563wil_lied
willowed15156763willowed
wilted103915713wil__ted
winded114918213wind__ed
winder104025263winder__
winders113721263winder_s
windled123713483wind_led
windowed1635573windowed
winterer112110443winterer
winterfed1644993winterfed
wired95327643wi___red
wiredrew1562873wiredrew
witherer14187953witherer
witherod15156153witherod
wizened20275423wi_zened
wonderer12249183wonderer
wuthered15157433wuthered
zippered22244823zippered

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621706.87621256.8
3Display Results1701700.0602833.3
 (SQL Overall)1786911707.38924183.4
 
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.