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

265 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
surlily1031000(None) 
burlily1237711burlily
curlily1238381curlily
furrily1337612furrily
murkily16287112murkily
pursily1238212pursily
scurvily1643782scurvily
shrilly13318562shrilly
sillily10209782sillily
slily85820032s__lily
sorrily1039832sorrily
sturdily1245082sturdily
sulkily14218112sulkily
sully84622902su_l_ly
sunnily1037832sunnily
surely93816462sur_ely
surlier72915442surlier
surly85124432sur__ly
uglily1036192_uglily
aerily93017013aer_ily
airily93014823air_ily
artily92814713_artily
aurality1139223aurality
aurally10310543aurally
blurrily1343913blurrily
bulkily16227123bulkily
bully105124813bu_l_ly
bumpily1665653bumpily
burbly134311153bur_bly
burley114715753burl_ey
burlier93514413burlier
burling104421133burling
burly104922833bur__ly
bushily15268893bushily
busily112211503bu_sily
cornily12410853cornily
crusily12199093crusily
cully105520463cu_l_ly
curably142010773curably
curlier93314183curlier
curling104320183curling
curly105321233cur__ly
curtly1149283cur_tly
cushily15257923cushily
daylily1434983daylily
dirtily1138583dirtily
drily95816523_dr_ily
duality1147963duality
dually103210063dual_ly
dully94921633du_l_ly
dumpily1566233dumpily
durably13229053durably
duskily15236743duskily
dustily113211523dustily
eerily92913563eer_ily
frilly124111443_frilly
fuggily1534963fuggily
fully114820863fu_l_ly
funkily1736513funkily
funnily1336373funnily
furling114016563furling
furmity1535183furmity
fussily13267603fussily
fustily133111373fustily
fuzzily2145073fuzzily
godlily1235343godlily
gorily10612503gor_ily
guiltily1243423guiltily
gullibly1443473gullibly
gully94020683gu_l_ly
gushily14257823gushily
gustily113010903gustily
gutsily11267223gutsily
hardily143310273hardily
holily123612953_holily
hornily1338283hornily
horsily1338843horsily
huffily1934693huffily
hurley125012523hurl_ey
hurlies103315333hurlies
hurling113616413hurling
hurly115819293hur__ly
huskily17236333huskily
jerkily2134623jerkily
jollily1745773jollily
juicily1935493juicily
jumpily2174983jumpily
jurally1736963jurally
lily76730183___lily
lowlily1335353lowlily
luckily16297083luckily
lumpily1476563lumpily
luridly1196283luridly
lustily103611243lustily
manlily1238743manlily
merrily1238633merrily
mirkily16266403mirkily
muckily18277743muckily
muddily1435963muddily
muggily1435103muggily
murkly15368303mur_kly
mushily152410093mushily
muskily16289043muskily
mussily12279773mussily
mustily123613633mustily
muzzily2045023muzzily
nervily1336863nervily
nullify1334713nullify
nullity1037363nullity
nurling84215823nurling
nuttily10308633nuttily
oilily93111723_oilily
perkily1637813perkily
publicly1743313publicly
pudgily1434903pudgily
puffily1834843puffily
pulpily1436103pulpily
punily11311773pu_nily
purely114013633pur_ely
purify14399153pur_ify
purity114114913pur_ity
purlieu938143purlieu
purlin83615863purli_n
purline93516533purline
purling103620293purling
purlins93415423purlins
purply13369053pur_ply
pushily15247983pushily
quakily2336693quakily
qualify2235473qualify
quality1938563quality
quirkily2442593quirkily
roily86121113__roily
ruddily1236303ruddily
rurality1137403rurality
rurally1038303rurally
rustily103112993rustily
ruttily10338613ruttily
salify12311373s_alify
sally85129713s_al_ly
saltily10310543saltily
sappily1437163sappily
sassily1038723sassily
saucily1237913saucily
savvily1634323savvily
scarily12311703scarily
scrawly15197193scrawly
scummily1743303scummily
scurril945113scurril_
scurrile1055073scurrile
seedily1178583seedily
serail64222673serail_
serails73318363serails
servile10310643servile
sexily1638853s_exily
shadily1437723shadily
shakily1736903shakily
shelly124414473shel_ly
shily115222013s__hily
shinily13268933shinily
showily1636223showily
shrill94712303shr_ill
shrills10389933shrills
sicklily1744293sicklily
silkily14236963silkily
silly84527623s_il_ly
slimily1247713slimily
slimly11408903s__limly
slimy105417423s__limy
slushily1445013slushily
slyly11489533s__lyly
smarmily1543523smarmily
smelly114110363smel_ly
smirkily1753333smirkily
smokily1635373smokily
smudgily1543123smudgily
smuttily1344273smuttily
snakily1436913snakily
snarkily1534583snarkily
snowily1336883snowily
snuffily17124323snuffily
soapily1237963soapily
soggily1235953soggily
solely93714213s_olely
solidly1137353s_olidly
sootily101810523sootily
sordidly1344663sordidly
sorely94618013sor_ely
sourly93612213sour__ly
sparkily1735023sparkily
spicily1438653spicily
spikily1635873spikily
sportily1337733sportily
sprawly15166043sprawly
spryly1435513spr_yly
spunkily1733773spunkily
squalidly2242323squalidly
squally1937673squal_ly
stagily1139053stagily
stalely1039213stalely
stalkily1534823stalkily
stilly93714093stil_ly
stolidly1243833stolidly
stonily1049433stonily
stormily1345243stormily
straitly1136563straitly
stripy115812743str_ipy
stubbily1564243stubbily
stuffily17124163stuffily
suably112814533su_ably
suavely1376493suavely
suavity1336313suavity
subfile122010503subfile
sublime11310363sublime
sublimely1643923sublimely
subline9316893subline
subsidy1345973subsidy
subtile91912623subtile
subtilty1345453subtilty
subtly11249263su_btly
sulky124715363su_l_ky
sullenly1145693sullenly
sullied83714483sullied
sullies74122233sullies
sultrily1146493sultrily
sultry938463su_ltry
sundrily1246063sundrily
sunlike112310573sunlike
sunlit61516103sunli_t
supplely1543063supplely
supply1346893su_pply
sural55931263sur_al_
surety93515013sur_ety
surfier102613543surfier
surfing112914483surfing
surflike1535933surflike
surfy115319473sur__fy
surgery11319213surgery
surging93115433surging
surgy95118523sur__gy
surimi839103sur_imi
surliest82416913surliest
surmise9311083surmise
surplice1246203surplice
surrey94414583sur_rey
surtitle845283surtitle
surveil1045093surveil_
surveils1144523surveils
survey124111673sur_vey
survive1335933survive
suslik1036373susli_k
susliks1136443susliks
tardily11269583tardily
tartily103511573tartily
tuftily1335573tuftily
turbidly1443683turbidly
turgidly1343353turgidly
uglify1333913_uglify
usually1066063usual_ly
verily122616053ver_ily
warily122915093war_ily
wilily123310763_wilily
wirily123310783wir_ily
wordily1437853wordily
worldly1433993worldly

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272657.00019146.7
3Display Results2652650.0932849.5
 (SQL Overall)1786912657.49923828.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.