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

121 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
worldly143396(None) 
boldly12399422bo_ldly
coldly12459952co_ldly
lordly1038752lor_dly
unworldly1651942unworldly
wildly13328122w_ildly
woolly12408512wool_ly
wordily1437852wordily
wordy126916162wor_d_y
workday1843302workday
world96915362world__
worlds10568732world_s
acridly13396533acridly
aridly105513703_aridly
baldly12479833_baldly
broadly1337153broadly
brolly114510853brol_ly
burlily1237713burlily
childly1644803childly
colly104926773co_l_ly
coolly114811393cool_ly
cornily12410853cornily
corody12149703corod_y
cowedly1635693cowedly
curlily1238383curlily
dolly96125203do_l_ly
drolly105411673drol_ly
floridly1554593floridly
folly115022603fo_l_ly
fondly13299043fo_ndly
forcedly1744793forcedly
forkedly1944313forkedly
foully1239013foul_ly
godlily1235343godlily
godly104913293go__dly
golly95121103go_l_ly
goodly11419303go_odly
gorgedly1443993gorgedly
gorily10612503gor_ily
hardly135112833har_dly
holily123612953ho_lily
holly114824433ho_l_ly
hornily1338283hornily
horridly15114783horridly
horsily1338843horsily
jollily1745773jollily
jolly154517513jo_l_ly
lolly85120663lo_l_ly
loudly1037783lo_udly
lowlily1335353lowlily
luridly1196283luridly
mildly12318243_mildly
moldy115014653mo_ld_y
molly105222493mo_l_ly
morally12411493morally
morbidly1643833morbidly
mouldy12437413mould_y
notedly1136883notedly
oddly1037163_o_ddly
oilily93111723_oilily
oldy85316843_o_ld_y
orally93113593_orally
portly114713403por_tly
proudly1336323proudly
redly94217193__redly
roundly1136723roundly
solely93714213so_lely
solidly1137353solidly
sordidly1344663sordidly
sorely94618003sor_ely
sorrily1039823sorrily
soundly1136683soundly
surlily1039993surlily
tiredly1136783tiredly
torpidly1483643torpidly
torridly1284463torridly
trolly94012353trol_ly
waddly14478723w_addly
wally114625093w_al_ly
warily122915093war_ily
warmly14228063war_mly
weirdly14274493weirdly
welly114620013w_el_ly
wholly15366573whol_ly
wieldy13476183wield_y
wilily123310763w_ilily
willy115321913w_il_ly
wirily123310783wir_ily
woald94813073woald__
woalds10427583woald_s
wobbly16347093wo_bbly
wofully1644523wofully
wold85429073wo_ld__
wolds95420183wo_ld_s
womanly1535853womanly
wontedly1544253wontedly
woodsy13505923wo_odsy
woody125116883wo_od_y
woollily1443123woollily
wooly114417673wo__oly
woozily2234383woozily
word89832003wor_d__
worded114316623wor_ded
wordplay1752753wordplay
words95425073wor_d_s
workably2044743workably
workaday1942273workaday
workdays1942903workdays
worldlier1342163worldlier
worldling1442893worldling
wormil1138043wormil_
wormils1236733wormils
wormy137514253wor__my
worriedly1642633worriedly
worry116114333wor__ry
worthily1745253worthily
worthy15598803wor_thy
would95513153would__
wouldst1134063wouldst
wrongly1434553wrongly
wryly14356703w_r_yly

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271218.00016753.4
3Display Results1211210.0502420.0
 (SQL Overall)1786911218.20321783.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.