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

203 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
thistle1010780(None) 
thistles1198231thistles
thistly1395961thistly
whistle13107531whistle
bhistie1236772bhistie
bristle91910102bristle
epistle957892epistle
gristle8169222gristle
hustle93113992_hustle
istle52214712__istle
thimble1435872thimble
thistlier1243652thistlier
throstle1175702throstle
title54721072t_i_tle
tittle63613322t_ittle
trestle72611362trestle
triste63818642trist_e
whistled1595782whistled
whistler1496312whistler
whistles14108212whistles
whittle13106102whittle
aisle55223193_ais_le
anisole71010833anisole
apostle937853apostle
aristae7312533aristae
bhisties1339003bhisties
bistre83815023_bistre
bristled11187343bristled
bristles101510433bristles
bristly12178063bristly
brittle9168603brittle
bustle84015483_bustle
castle84918963_castle
chaste114617393chast_e
chicle134312543chi_cle
chile105626893chi__le
chipotle1543653chipotle
chisel112111943chisel_
chiseled1435883chiseled
chiseler1335903chiseler
chisels12219103chisels
chortle124210443chortle
christie1347783christie
cristae9310613cristae
cuittle946403cuittle
enisle63412093enis_le
epistler1044833epistler
epistles1047783epistles
epistyle1364073epistyle
ghastly14354563ghastly
ghostly14355103ghostly
gristles9189203gristles
gristly11187333gristly
hantle94318203_hantle
hassle93711593_hassle
haste85927863_hast_e
higgle113811743_higgle
hirple11158973_hirple
hirsle9159573_hirsle
hist76551543_hist__
histed104420243_histed
histone10312843_histone
hists86328373_hist_s
hostel93914153_hostel
hostile10312553_hostile
hostler103411023_hostler
hostly124210863_hostly
hurtle93512943_hurtle
hustled113210133_hustled
hustler103410753_hustler
hustles103414173_hustles
isle45121703__is_le
istles62814983__istles
ixtle12168013__ixtle
jostle13319863_jostle
justle133211583_justle
kirtle10309473_kirtle
kittle104012173_kittle
lisle53916723_lis_le
listee64223063_listee
listel64214743_listel
little63312163_little
moistly1236613moistly
nestle63013953_nestle
outhustle1253053outhustle
pestle83215843_pestle
philtre12105213philtre
pintle83818263_pintle
piste75824603_pist_e
pistole92414313_pistole
rustle63615413_rustle
shingle117711283shingle
shist84829613shist__
shists96515113shist_s
shuttle1046103shuttle
skittle1135533skittle
spittle937923spittle
tachiste1356213tachist_e
taille63116923tai_lle
taste55127233t_ast_e
tattle64115653t_attle
tensile72612733tensile
testae64216253t_estae
testee64323303t_estee
theatre10358493theatre
theist9314763theist__
theistic1348153theistic
theists1039153theist_s
these86519013thes__e
thiazole2042883thiazole
thickly19415573thickly
thieve1235963thi_eve
thill85918733thi__ll
thills95515383thi_lls
thimbles1536023thimbles
thine85026863thi__ne
thinly1238673thi_nly
thiol87616043thi_ol_
thiols95112763thi_ols
thirdly1444633thirdly
thirl85416823thi_rl_
thirled11328093thi_rled
thirls95012063thi_rls
thirst9312253thirst__
thirsted1235213thirsted
thirster1135673thirster
thirstier1243693thirstier
thirstily1542693thirstily
thirsts1036243thirst_s
thirsty1354083thirst_y
thirteen1143303thirteen
thirties1139723thirties
thirty12378403thirt_y
this76027383this___
thistliest1344383thistliest
thither13328103thi_ther
thole85620843th__ole
those85218143thos__e
throstles1265903throstles
throttle1164083throttle
thusly1235133thus_ly
thyself1643033thyself
tickle124616743t_ickle
tile45451443t_i__le
tingle74319063t_ingle
tinkle103714453t_inkle
tipple103411913t_ipple
tiptoe838283t_iptoe
tisane6311573t_isane
tissue637333t_issue
tithe85319703t_i_the
titled73815003t_i_tled
titles63719923t_i_tles
titre54619393t_i_tre
tittie63213153t_ittie
tittles73413253t_ittles
toile54626493toi__le
tootle62613813t_ootle
tousle64514653tous_le
trestles83012553trestles
triable92515393triable
trickle133613443trickle
trifle94012883tri_fle
trindle83311363trindle
triple84215923tri_ple
triscele1045433triscele
triseme936543triseme
triskele1244573triskele
trisome9310223trisome
tristate8311033tristate
trite54730033tri_t_e
trustee73514443trustee
tryste9399583tryst_e
tuille63012643tui_lle
turtle63213573t_urtle
tussle637143t_ussle
twattle1064273twattle
twiddle12305483twiddle
twinkle1464773twinkle
twist86820983twist__
twistable1444273twistable
twisted11277433twisted
twister10308953twister
twistier1134813twistier
twists9549753twist_s
twisty12426863twist_y
vittle94711753_vittle
warstle10328013warstle
whiffle1933533whiffle
while115418693whi__le
whist115322953whist__
whisted144010013whisted
whistlers1595163whistlers
whists124613813whist_s
white114920303whi_t_e
whittled1594913whittled
whittler1495193whittler
whittles1496673whittles
whortle13335943whortle
wintle94014603_wintle
wrastle10368993wrastle
wrestle10298843wrestle
wristlet1138643wristlet

Search took 10 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.813219792.1
2DLD Change Limit1340272038.53315706.9
3Display Results2032030.0762671.1
 (SQL Overall)1786912039.42218965.3
 
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.