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

495 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
thread10501109(None) 
threads11419951threads
thready14435901thready
threap11569661threap
threat95020461threat
tread64821701t_read
ahead96817052ah_ead
bread85523112_bread
dread74419022_dread
head87137172_h_ead
oread64619602_oread
phreak1536152phreak
read55942532__read
reread71715432reread
rethread1245352rethread
shred98125612shre_d
shrewd136810782shrewd
spread9312532spread
tared69340052tare_d
thereat104315242thereat
thraw1110515922thr_aw
threaded1366322threaded
threader1256732threader
threaped1454862threaped
threaps12488642threaps
threated1259202threated
threats104311672threats
three87526912thre_e
threep115910112threep
threes97117322threes
thresh12276862thresh
threw1117315712thre_w
throat94819752throat
tired65228902tire_d
trad55630912t_r_ad
treads74817922t_reads
treat56240352t_reat
treed65626732t_reed
trend64817452t_rend
triad65217722t_riad
tyred95816432tyre_d
unread73412672unread
unthread1244602unthread
abroad9310943abroad
acred87126353acre_d
agreed84712503agreed
ahed89536253ah_e_d
aired66032923aire_d
airhead1136993airhead
already1144263already
area45843393_area_
areae55229743_areae
areal55928733_areal
areas55935773_areas
arrear6310253arrear
bared85144483bare_d
bead75937923__bead
behead1239923behead
boreal84817213boreal
boreas85421733boreas
bored85034303bore_d
brad75234343_br_ad
breads95419203_breads
bready124511183_bready
break115319403_break
bream95121813_bream
bred75130973_bre_d
breed85526693_breed
broad84817693_broad
bureau8712523bureau
byroad1236623byroad
cared86050093care_d
cathead1338753cath_ead
cereal8315833cereal
cered85227443cere_d
chad105525503ch__ad
chared125423693chare_d
cheap126915943ch_eap
cheat105732453ch_eat
chield124610213chield
chorea115216083chorea_
choreal124412223choreal
choreas124414203choreas
chored125321883chore_d
chresard1444063chresard
cohead123811123cohead
colead94114643colead
cored85044223core_d
creak115418433_creak
cream95721353_cream
cred76530883_cre_d
creed85727393_creed
cured85932133cure_d
dared75935013dare_d
dead65434243__dead
delead84112343delead
dorsad8408973dorsad
dreads84115023_dreads
dream85120393_dream
drear65016903_drear
dreed75222843_dreed
dryad10477583_dryad
dured75025403dure_d
eared65139503eare_d
ennead736253ennead
erred65915673erre_d
ethereal1146783ethereal
farad95720673far_ad
fared95842343fare_d
fathead1437863fath_ead
fired94829743fire_d
forbad122710503forbad
freak125115243_freak
freed95223543_freed
fremd115010323_fremd
gherao1036753gherao
gored75227083gore_d
grad66829863_gr_ad
great66034243_great
greed75125693_greed
gyred105114093gyre_d
had77658763_h__ad
haed86338583_hae_d
hared95742183hare_d
heads95127113_h_eads
heady125117263_h_eady
heal75645693_h_eal
heap96432893_h_eap
hear76143883_h_ear
heard95222753_h_eard
heat77061423_h_eat
heed86437603_h_eed
held85330403_h_eld
herald10311343_herald
herd84933063_h_erd
hereat93527413hereat
hexad164910623_hexad
hied85434043_hie_d
hired95226263hire_d
hodad10311353_hodad
hoed87837983_hoe_d
hothead14349293hoth_ead
hued86925853_hue_d
ihram10310183ihr_am
inroad737933inroad
ired55131873_ire_d
irreal657833irreal
jarhead1835173jarhead
jereed144012073jereed
kheda1346533kh_eda
knead10429663_knead
lead56038853__lead
lipread1034953lipread
loreal63814313loreal
lured65427493lure_d
mead75531603__mead
mired85729223mire_d
misread10339723misread
mured85726703mure_d
myriad1235913myriad
nereid7312923nereid
oared65030653oare_d
ochrea11316643ochrea_
ochreae12295083ochreae
ochred12328003ochre_d
ocrea73311823ocrea_
ocreae83310273ocreae
ohed87825183oh_e_d
orad56031693_or_ad
oreads73915773_oreads
outread82811093outread
pared86946763pare_d
perea75026443perea_
phreaked1834493phreaked
phreaks1634543phreaks
pithead13419593pith_ead
plead85818463_plead
pored85234513pore_d
pothead133810393poth_ead
preed85128123_preed
pureed95017813pureed
rad47662003__r_ad
rared65738323rare_d
readd74617133__readd
reads64835273__reads
ready94821503__ready
real45750293__real
ream65841613__ream
reap65934743__reap
rear45644553__rear
red46755803__re_d
redd66323173__redd
reed55549623__reed
rend56136573__rend
rereads81512293rereads
rethreads1344483rethreads
retread849003retread
rhea75017433rh_ea_
rheas84816953rh_eas
road56332113__road
screak125311063screak
scream104814253scream
screed95718933screed
sered65737293sere_d
shad86230913sh__ad
shared105829063share_d
shea76031573sh_ea_
sheaf115424123sh_eaf
sheal84927703sh_eal
shear85424833sh_ear
sheas86331793sh_eas
shed86536153sh_e_d
shend94719973sh_end
sherd96321153sh_erd
shied96125493shie_d
shield106212973shield
shmear1176933shmear
shoed95723013shoe_d
shored105723653shore_d
shreds105613053shreds
shrew119720173shre_w
shrewed14589853shrewed
shrews129313923shrews
shroud1038773shroud
sired66134283sire_d
sored66141783sore_d
spreads1039763spreads
stared75429873stare_d
stead65520273_stead
stored75524213store_d
streak104613623streak
stream84717293stream
tad47959823t___ad
tamed85528513tame_d
taped85327423tape_d
tare45957623tare__
tares57456563tare_s
tarmac10310333tarmac
tarnal63716503tarnal
tarpan82814293tarpan
tarred74720283tarred
tarsal63315273tarsal
tartan64217513tartan
tartar63214753tartar
tarted74923373tarted
tarweed1137343tarweed
tarzan152910753tarzan
tawed95926193tawe_d
taxed135620293taxe_d
tea37353323t__ea_
teak85930843t__eak
teal45546503t__eal
team66238653t__eam
tear45242883t__ear
teared75722153teare_d
teas45851493t__eas
teat45963633t__eat
ted46446563t__e_d
teed55439263t__eed
tend56433773t__end
terai53525483ter_ai
teredo7310783teredo
terefah1344113terefah
terete6319333terete
terga63315643terga_
tergal72912833tergal
termed94816703termed
terra54419663terra_
terrae62915213terrae
terras63516973terras
tetrad73612053tetrad
tewed94718533tewe_d
thae76825563th__ae
than76128773th__an
that75639323th__at
thaw107521313th__aw
thawed13458463thawed
the67436053th_e__
thebe107515433th_ebe
theca103311453th_eca
thecae11299653thecae
thecal113310303thecal
thee78039063th_e_e
theft114118133th_eft
thegn95810903th_egn
thein85919023th_ein
their85512153th_eir
them97427043th_e_m
theme105921733th_eme
themed125912583themed
then78429693th_e_n
thenal92712423thenal
thenar92610003thenar
thens85921833th_ens
therapy1536613therapy
there87527393th_ere
thereby1534633thereby
therein102310353therein
thereof13168063thereof
thereon10199263thereon
theres96525473theres
thereto1038993thereto
theriac1239143theriac
therian10311293therian
therm106018023th_erm
thermae125310503thermae
thermal125010973thermal
therme115814993therme
therms115914873therms
theroid11313403theroid
these86519013th_ese
thesp105410313th_esp
theta83414573th_eta
thetas93011573thetas
thew108226233th_e_w
thews117416193th_ews
thewy146311853th_ewy
they107223753th_e_y
thief114516303thie_f
thieve1235963thieve
thieved1434973thieved
thiram1139963thiram
third95912493th_ird
thirled11328093thirled
tholed105113873tholed
thorax1638253thorax
thoria93012893thoria_
thorias102312053thorias
thorned11479403thorned
thoued10429003thoued
thrall93810293thrall
thrash12258363thrash
thrave126010273thrave
thrawed1435583thrawed
thrawn12769423thrawn
thraws129211103thraws
threaders1365743threaders
threadfin1641953threadfin
threadier1354473threadier
threading14107593threading
threaper1345143threaper
threaten1146303threaten
threeped1454373threeped
threeps12687043threeps
threnode1255423threnode
threnody1543323threnody
threshed1535643threshed
thrice114311573thrice
thrift12412043thrift
thrill94910593thrill
thrip103012183thr_ip
thrips11299013thrips
thrive125313223thrive
thrived14458183thrived
thro77726423thr__o
throated1247923throated
throats104612193throats
throaty13428483throaty
throb109816853thr_ob
throbs118311373throbs
throe89321423thr_oe
throes97518673throes
throne98517603throne
throned115412173throned
throng10539973throng
throve128012393throve
throw118719733thr_ow
thrown1214911443thrown
throws129715233throws
thru76818943thr__u
thrum104713633thr_um
thrums11429123thrums
thrush12257483thrush
thrust91911893thrust
thruway1643163thruway
thud85613913th__ud
thuja1535213thuja_
thujas1634433thujas
thuya1135583thuya_
thuyas1234773thuyas
thyreoid1544773thyreoid
thyroid1438253thyroid
tiaraed837053tiaraed
tided76322513tide_d
tied55535213t_ie_d
tiered73613973tiered
tiled64832943tile_d
timed85223613time_d
tinea54923163tinea_
tineal66216163tineal
tineas64616483tineas
tined65434533tine_d
tineid74412023tineid
tirade7311693tir_ade
tire46143353tire__
tires55437493tire_s
tirled74714363tirled
toad55830183t__oad
toea46732333t_oea_
toeas55726423t_oeas
toed56137043t_oe_d
togaed84711343togaed
toked105626493toke_d
toled65934923tole_d
toned65435343tone_d
toped85631313tope_d
tora47545993tor_a_
torah87125273tor_ah
toras55540373tor_as
tore47359323tore__
toreador945003toreador
torero6313203torero
tores55352673tore_s
tornado845673tornado
toroid7416013toroid
torpid9310913torpid
torrid7311853torrid
torsade837593torsade
torta55925353torta_
tortas64918253tortas
toted64929483tote_d
toured74216153toure_d
towed95134583towe_d
towhead1435223towhead
toyed96019803toye_d
trade65026043t_r_ade
tram67034553t_r_am
trap67532803t_r_ap
tray77632593t_r_ay
treaded95014283t_readed
treader84113833t_reader
treadle8310103t_readle
treated83618703t_reated
treats64821693t_reats
treaty94414353t_reaty
tree47745813t_re_e
treen55622753t_reen
trees55835763t_rees
tref77030993t_re_f
trefah1235093t_refah
trek86222313t_re_k
treks96016853t_reks
trends75513543t_rends
trendy10469603t_rendy
trepan82511673t_repan
trepid9310083t_repid
tres46542903t_re_s
tress55423163t_ress
tret46653533t_re_t
trets55928023t_rets
trews86118893t_rews
trey77228793t_re_y
treys85018213t_reys
triac74116373t_riac
triads74513533t_riads
trial54926353t_rial
tried65026913t_ried
troak95213573t_roak
trod57627953t_r_od
trued65117693t_rued
tsked105910033tske_d
tubed85818043tube_d
tuned64622313tune_d
turban8310483turban
turbid979713turbid
turd56027623tur__d
tureen63312723tureen
turfed103110963turfed
turgid868013turgid
turned73914473turned
tweak1257753t_weak
tweed94915093t_weed
tyned95915013tyne_d
typed115815453type_d
tyre75428253tyre__
tyres84725233tyre_s
undead82711903undead
unlead73312373unlead
unready11215943unready
unreal64414453unreal
unthreads1343633unthreads
untread857413untread
uprear8168793uprear
urea46528053_urea_
ureal56722683_ureal
ureas55826013_ureas
wared96339873ware_d
warhead1436603warhead
wheal115716183wh_eal
wheat114924573wh_eat
whereas13448903whereas
whereat134311923whereat
whored135512123whore_d
wired95327643wire_d
wreak125513273_wreak

Search took 7 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 Filter1786911127160.376475242.0
2DLD Change Limit1127164955.90619085.0
3Display Results4954950.1702911.8
 (SQL Overall)1786914956.45227695.4
 
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.