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

183 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
thrilled123549(None) 
shrilled1246861shrilled
thralled1245801thralled
thriller1165551thriller
trilled84116311t_rilled
chilled133310932ch_illed
drilled94711672_drilled
frilled113911602_frilled
grilled94012832_grilled
hilled104022222_h_illed
perilled11410092perilled
prilled104712992_prilled
rilled74525652__rilled
shilled113313622sh_illed
shriller1136822shriller
thirled11328092th_irled
thrill94910592thrill__
thrillers1244472thrillers
thrills10398782thrill_s
thrived14458182thri_ved
tilled74722952t__illed
trifled113711962t_rifled
triller74215892t_riller
tripled104113832t_ripled
trolled84312262t_rolled
twilled11398032t_willed
anvilled1236483anvilled
ariled75620323_ari_led
auricled11135703auricled
billed94224903__billed
brailled1147193brailled
bridled113611143_bridled
carolled1138823carolled
cavilled1436733cavilled
chiller124112183ch_iller
devilled1336743devilled
dilled84122223__dilled
driller84311883_driller
drolled93810223_drolled
enrolled967963enrolled
enthralled1443693enthralled
filled104922263__filled
friller104111743_friller
gilled84521633__gilled
grille74315743_grille_
griller84513353_griller
grilles83715023_grilles
hailed104122743_hai_led
heiled104415613_hei_led
helled104024703_h_elled
hiller94421633_h_iller
hilloed113211293_h_illoed
hilted104016043_h_ilted
hirpled13157133_hirpled
hirsled11118113_hirsled
hulled103920013_h_ulled
inthralled1443763inthralled
killed113918773__killed
milled94326173__milled
muralled1136423muralled
nilled73919453__nilled
periled10316303peri_led
pilled94222753__pilled
quilled17329283_quilled
rebilled11318053rebilled
redrilled1145353redrilled
refilled12278673refilled
rerolled93010043rerolled
rifled104115003__rifled
riled65833253__ri_led
rille55728733__rille_
rilles64725503__rilles
rillet64828853__rillet
rolled74220243__rolled
scrolled1137043scrolled
shelled113815083sh_elled
shrieked16265173shrieked
shrieved15276073shrieved
shrill94712303shrill__
shrillest1245393shrillest
shrills10389933shrill_s
shrilly13318553shrill_y
shrimped1634213shrimped
shrined114112413shri_ned
shrived144712183shri_ved
shriveled1643153shriveled
shrivelled1742373shrivelled
skilled123110863_skilled
spilled103613623_spilled
stilled83314783_stilled
strolled937813strolled
swilled113611833_swilled
tailed74424663t_ai_led
taille63116923t_aille_
tailles72516473t_ailles
tariffed1533723tariffed
tendrilled1242963tendrilled
thieved1434973th_ieved
thighed1535273th_ighed
thill85918733th_ill__
thills95515383th_ill_s
thinned11399163th_inned
thirsted1235213thirsted
tholed105113873th__oled
thrall93810293thrall__
thralls10299043thrall_s
thrashed1555363thrashed
thrawed1435583thr_awed
threaded1366323threaded
threaped1454863threaped
threated1259203threated
threeped1454373threeped
threshed1535643threshed
thrice114311573thri_ce_
thrilling13276693thrilling
thrive125313223thri_ve_
thriven13447023thri_ven
thriver13479123thri_ver
thrives134611713thri_ves
throated1247923throated
throbbed1643163throbbed
throned115412173thr_oned
thronged13405333thronged
throttled1352963throttled
thrummed1642843thrummed
thrusted1265223thrusted
thurible1343353thurible_
thuribles1442523thuribles
tiled64832943t__i_led
tiller64222543t__iller
tilted74616863t__ilted
tirled74714363t__irled
titled73815003t__itled
toiled74420323t_oi_led
tolled73819033t__olled
totalled935843totalled
towelled1236353towelled
trailed83415673t_railed
trawled113411523t_rawled
trebled1038483t_rebled
triaged92810443t_riaged
triced95518673t_ri_ced
tricked144016163t_ricked
trickled152610433t_rickled
triclad1037443t_riclad
tried65026913t_ri__ed
trifle94012883t_rifle_
trifler103912153t_rifler
trifles103814823t_rifles
trigged10359853t_rigged
trill55122933t_rill__
trillers83613493t_rillers
trills64319853t_rill_s
trilobed1144203t_rilobed
trimmed12348933t_rimmed
trindled10388693t_rindled
trined74920713t_ri_ned
triolet73219523t_riolet
triple84215923t_riple_
triples94616873t_riples
triplet94319213t_riplet
triplex16447803t_riplex
tripped123911693t_ripped
troller73913173t_roller
trolley10328753t_rolley
trollied935893t_rollied
tuille63012643t_uille_
tuilles72411923t_uilles
turtled8309683tur_tled
twirled11385983t_wirled
unbilled1188693unbilled
undrilled1146663undrilled
unfilled1298383unfilled
unmilled1197853unmilled
unrifled1237423unrifled
unrolled9610413unrolled
untilled9710563untilled
unwilled1277823unwilled
whiled134514133wh_i_led
whirled14368043wh_irled
willed104722453__willed
zorille1636673zorille_
zorilles1736123zorilles

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621838.36017483.5
3Display Results1831830.0802287.5
 (SQL Overall)1786911838.59620787.7
 
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.