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

255 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
thighed153527(None) 
higher134610892_higher
highted152710162_highted
neighed12135892neighed
nighed113811292_nighed
sighed113712052_sighed
thieved1434972thieved
thigh12410122thigh__
thighs1346632thigh_s
thinned11399162thinned
thirled11328092thirled
thither13328102thither
tithed104115592t_ithed
toughed123511692toughed
trigged10359852trigged
twigged13345282twigged
weighed15135932weighed
whished17428022whished
alighted1347673alighted
aligned9128553aligned
bighead14126653_bighead
bighted142810923_bighted
blighted1546863blighted
boughed143810263boughed
chided135113963chi_ded
chigger1436003chigger
chigoe1237533chigoe_
chigoes1338353chigoes
chilled133310933chilled
chimed145814833chi_med
chined125620063chi_ned
chinked174011023chinked
chinned134810493chinned
chipped174110813chipped
chirked173810333chirked
chirmed15379733chirmed
chirped15379783chirped
chirred133612123chirred
chivied16368383chivied
chugged1584823chugged
cliched153711023cliched
coigned11418663coigned
coughed143310903coughed
deigned1037503deigned
digged104314653_digged
dighted132511493_dighted
dished114318713_dished
faithed1437163faithed
feigned1245353feigned
figged124013893_figged
fished134316313_fished
flighted1646973flighted
frigged13439053frigged
frighted1657173frighted
gigged104112293_gigged
gighe10139733_gighe_
hagged124317703_hagged
hashed136021943_hashed
hided105222443_hi_ded
hied85434043_hi__ed
higgled13339073_higgled
high116619923_high__
highbred1843373_highbred
highest1439563_highest
highly1636823_highly
highs125412523_high_s
hight125327233_high_t
highth12389153_highth
hights133716893_hights
hiked135919203_hi_ked
hilled104022223_hilled
hilted104016043_hilted
hinged114618923_hinged
hinted104318323_hinted
hipped144317693_hipped
hired95226263_hi_red
hissed104114453_hissed
histed104420243_histed
hitched163312253_hitched
hither124417253_hither
hived125217913_hi_ved
hogged125817773_hogged
hugged124113643_hugged
hushed134416673_hushed
igged86012763__igged
jigged164412773_jigged
kithed144613013_kithed
knighted1745123knighted
laughed1235893laughed
lighted122913503_lighted
miched143913393_miched
niched125514063_niched
nigher103612753_nigher
pigged114214153_pigged
pished124817063_pished
pithed124615613_pithed
plighted1546463plighted
prigged12398933prigged
reigned949213reigned
rigged94517403_rigged
righted122912143_righted
roughed124210943roughed
shagged134210133shagged
shied96125493shi__ed
shifted14359983shifted
shilled113313623shilled
shimmed15338583shimmed
shined104620783shi_ned
shingled13358323shingled
shinned114310913shinned
shipped153312103shipped
shirked153710463shirked
shirred113710503shirred
shithead1535523shithead
shitted114212053shitted
shogged13397963shogged
shushed14348493shushed
sigher103813703_sigher
sighted123111523_sighted
signed83413753_signed
sleighed1334033sleighed
slighted1357393slighted
soughed123811623soughed
sughed113610203_sughed
swigged13327183swigged
swished14418843swished
tagged93418123t_agged
tailed74424663tai_led
tainted83512423tainted
tanged84622493tang_ed
tangled94214633tangled
tangoed9318833tangoed
teched124014433t_eched
teethed11318623teethed
tetched133010773tetched
thacked173810203thacked
thanked15469153thanked
thatched1735433thatched
thawed13458463th_awed
themed125912583th_emed
thicken16317873thicken
thicker163611023thicker
thicket163213073thicket
thickhead2242693thickhead
thief114516303thi__ef
thieve1235963thieve_
thieves1346903thieves
thine85026863thi_ne_
thinker143610683thinker
thinner10358973thinner
thiophen1643583thiophen
third95912493thi__rd
thirsted1235213thirsted
tholed105113873th_oled
thonged12376843thonged
thorned11479403thorned
thoued10429003th_oued
thrashed1555363thrashed
thrawed1435583thrawed
threshed1535643threshed
thrilled1235493thrilled
thrived14458183thrived
throned115412173throned
thudded1333433thudded
thuggee1245263thuggee
thumbed15336173thumbed
thumped15387413thumped
thunked15386853thunked
ticced11438443t_icced
ticked134720523t_icked
tided76322513t_i_ded
tidied83613273t_idied
tied55535213t_i__ed
tiered73613973t_iered
tiffed13368393t_iffed
tiger65718633t_ig_er
tight93626503t_igh_t
tighten11288973t_ighten
tighter112910693t_ighter
tights104015853t_ights
tiled64832943t_i_led
tilled74722953t_illed
tilted74616863t_ilted
timed85223613t_i_med
tined65434533t_i_ned
tinged84220803t_inged
tingled93712803tingled
tinned74317533t_inned
tinted74419533t_inted
tipped114418263t_ipped
tired65228903t_i_red
tirled74714363t_irled
tithe85319703t_ithe_
tither94920283t_ither
tithes94720213t_ithes
titled73815003t_itled
togaed84711343t_ogaed
togged95117513t_ogged
toggled10428653toggled
toiled74420323toi_led
toited74016753toi_ted
tonged86518903tong_ed
tongued946323tongued
toothed113310243toothed
torched133511353torched
touched134914963touched
toughen11329203toughen
tougher114210983tougher
trashed113514703trashed
triaged92810443triaged
triced95518673tri_ced
tricked144016163tricked
tried65026913tri__ed
trifled113711963trifled
trigger9329163trigger
trilled84116313trilled
trimmed12348933trimmed
trined74920713tri_ned
tripled104113833tripled
tripped123911693tripped
trothed114010973trothed
tugged93813523t_ugged
tushed104615893t_ushed
twiggen12333503twiggen
twilled11398033twilled
twined104413123twi_ned
twinged12398363twinged
twinned11366333twinned
twirled11385983twirled
twisted11277433twisted
twitched17155033twitched
twitted11326633twitted
tythed13457503t_ythed
weigher14136343weigher
weighted1635593weighted
whidded1634423whidded
whiffed2064473whiffed
whiled134514133whi_led
whined134715203whi_ned
whinged15409153whinged
whipped18379333whipped
whirled14368043whirled
whirred14386933whirred
whishes16309443whishes
whishted1843153whishted
whisked18336913whisked
whisted144010013whisted
whited134814083whi_ted
whither163510253whither
whizzed2234063whizzed
wigged124413583_wigged
wished134417513_wished
withed134416233_withed
writhed14389623writhed
zigged184110193_zigged

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.420425454.8
2DLD Change Limit1340272556.84319586.0
3Display Results2552550.0932741.9
 (SQL Overall)1786912557.35624291.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.