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

145 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
thrilling1327669(None) 
shrilling13307691shrilling
thralling13256831thralling
trilling92815961t_rilling
chilling143512182ch_illing
drilling103311982_drilling
frilling123011492_frilling
grilling103811532_grilling
hilling113821772_h_illing
perilling12410002perilling
prilling113413412_prilling
rilling84023622__rilling
shilling123315382sh_illing
thirling12248582th_irling
thrillingly1851712thrillingly
thriving15246352thri_ving
tilling83522782t__illing
trifling122411502t_rifling
tripling112712552t_ripling
trolling93212492t_rolling
twilling12268672t_willing
anvilling1336833anvilling
billing103823853__billing
brailling1247773brailling
bridling122610583_bridling
brisling112410843_brisling
carolling1259413carolling
cavilling1536383cavilling
childing15288503ch_ilding
chitling142910663ch_itling
devilling1436703devilling
drillings11285823_drillings
drolling103510763_drolling
enrolling1087733enrolling
enthralling1543843enthralling
filling113520803__filling
frillings13265803_frillings
gilling93520383__gilling
hailing113820693_hai_ling
heiling113616363_hei_ling
helling114623223_h_elling
hilding123713533_h_ilding
hilloing12158303_h_illoing
hilting113316893_h_ilting
hireling121210993_hireling
hirpling1467223_hirpling
hirsling1277543_hirsling
hulling113619013_h_ulling
inthralling1544113inthralling
killing123118723__killing
milling103223683__milling
nilling83619563__nilling
periling11316863peri_ling
pilling103722563__pilling
quilling182510003_quilling
rebilling12228833rebilling
redrilling1246073redrilling
refilling13299333refilling
rerolling102210373rerolling
rifling112815013__rifling
riling74227973__ri_ling
rolling83620413__rolling
schilling15286393schilling
scrolling12187803scrolling
shelling123515213sh_elling
shieling123512403sh_ieling
shillings13348093sh_illings
shrieking1734583shrieking
shrieving1633973shrieving
shrimping1734063shrimping
shrining122610853shri_ning
shrinking1735653shrinking
shriveling1743253shriveling
shrivelling1842213shrivelling
shriving15268453shri_ving
skilling132911333_skilling
spilling113113943_spilling
stilling93415323_stilling
stripling1257783stripling
strolling10238793strolling
swilling123511933_swilling
tailing82923103t_ai_ling
tariffing1644113tariffing
tefillin1143923tefillin_
telling83321083t__elling
thieving1535143th_ieving
thinking16289863th_inking
thinning12319093th_inning
thirsting1335283thirsting
tholing112812333th__oling
thrashing1635673thrashing
thrawing1535963thr_awing
threading14107593threading
threaping15106113threaping
threating131010043threating
threeping15104803threeping
threshing1645663threshing
thrill94910593thrill___
thrilled1235493thrill_ed
thriller1165553thrill_er
thrillers1244473thrillers
thrills10398783thrill__s
throating1398393throating
throbbing1743523throbbing
thronging1435073thronging
throning1238863thr_oning
throttling1442783throttling
throwing1536723thr_owing
thrumming1742903thrumming
thrusting1335003thrusting
tiling73426553t__i_ling
tilting83417103t__ilting
tirling83315733t__irling
titling83715793t__itling
toiling83219023t_oi_ling
tolling83418563t__olling
totalling1036523totalling
towelling1366253towelling
trailing92916093t_railing
trawling122710783t_rawling
trebling1139873t_rebling
triaging102610543t_riaging
tricing103417353t_ri_cing
tricking152714513t_ricking
trickling1647723t_rickling
triflings13235973t_riflings
trigging11299583t_rigging
trillion847973t_rillion
trillions947183t_rillions
trillium1046203t_rillium
trimming13318653t_rimming
trindling1137133t_rindling
trining82919213t_ri_ning
tripping133210923t_ripping
trithing122811773t_rithing
trollings10286693t_rollings
trollying1354053t_rollying
turtling9238833tur_tling
twillings13234913t_willings
twirling12246243t_wirling
unrolling1078563unrolling
unwilling1337163unwilling
whiling143511743wh_i_ling
whirling15237163wh_irling
willing113821613__willing

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 Filter1786911486410.313570897.8
2DLD Change Limit1486411458.50017487.2
3Display Results1451450.0632301.6
 (SQL Overall)1786911458.87620131.9
 
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.