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

334 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
threap1156966(None) 
thread105011091thread
threaps12488641threaps
threat95020461threat
threep115910111threep
cheap126915942ch_eap
heap96432892_h_eap
phreak1536152phreak
reap65934742__reap
therapy1536612therapy
thereat104315242thereat
thesp105410312th_esp
thraw1110515922thr_aw
threads11419952threads
thready14435902thready
threaped1454862threaped
threaper1345142threaper
threats104311672threats
three87526912thre_e
threeps12687042threeps
threes97117322threes
thresh12276862thresh
threw1117315712thre_w
thrip103012182thr_ip
throat94819752throat
trap67532802t_r_ap
tread64821702t_read
treat56240352t_reat
ahead96817053ah_ead
area45843393_area_
areae55229743_areae
areal55928733_areal
areas55935773_areas
arepa75615563_arepa
arrear6310253arrear
beleap10410283beleap
boreal84817213boreal
boreas85421733boreas
bread85523113_bread
break115319403_break
bream95121813_bream
bureau8712523bureau
burlap1098353burlap
cereal8315833cereal
chap114928493ch__ap
cheapo134810083ch_eapo
cheaps134613683ch_eaps
cheat105732453ch_eat
cheep125416503ch_eep
chorea115216083chorea_
choreal124412223choreal
choreas124414203choreas
crap85731843_cr_ap
creak115418433_creak
cream95721353_cream
creep95218103_creep
dread74419023_dread
dream85120393_dream
drear65016903_drear
earlap837183earlap
ethereal1146783ethereal
frap95925813_fr_ap
freak125115243_freak
gherao1036753gherao
great66034243_great
hap87360053_h__ap
head87137173_h_ead
heal75645693_h_eal
heaps105223223_h_eaps
heapy135914983_h_eapy
hear76143883_h_ear
heat77061423_h_eat
help95328923_h_elp
hemp115725623_h_emp
hep86644143_h_e_p
hereat93527413hereat
ihram10310183ihr_am
irreal657833irreal
kreep114610413_kreep
leap66032683__leap
loreal63814313loreal
neap66927013__neap
ochrea11316643ochrea_
ochreae12295083ochreae
ocrea73311823ocrea_
ocreae83310273ocreae
oread64619603_oread
perea75026443perea_
phreaks1634543phreaks
preamp1238993_preamp
preop94715873_preop
prep86427673_pre_p
rap56261963__r_ap
read55942533__read
real45750293__real
ream65841613__ream
reaps75626193__reaps
rear45644553__rear
recap95718023__recap
remap95418103__remap
rep55847803__re_p
repp85418743__repp
reread71715433reread
rethread1245353rethread
rhea75017433rh_ea_
rheas84816953rh_eas
scrap97120403scr_ap
screak125311063screak
scream104814253scream
shea76031573sh_ea_
sheaf115424123sh_eaf
sheal84927703sh_eal
shear85424833sh_ear
sheas86331793sh_eas
sheep105321523sh_eep
sherpa1138093sherpa
shlep104914833shle_p
shlepp13366193shlepp
shmear1176933shmear
shred98125613shre_d
shreds105613053shreds
shrew119720173shre_w
shrewd136810783shrewd
shrews129313923shrews
shrimp13478773shrimp
sneap75514823_sneap
spread9312533spread
strap77925263str_ap
streak104613623streak
stream84717293stream
strep77120853stre_p
takeup1234583takeup
tap57663873t___ap
tare45957623tare__
tared69340053tare_d
tares57456563tare_s
tarmac10310333tarmac
tarnal63716503tarnal
tarp66936413tar__p
tarpan82814293tarpan
tarsal63315273tarsal
tartan64217513tartan
tartar63214753tartar
tarzan152910753tarzan
tea37353323t__ea_
teak85930843t__eak
teal45546503t__eal
team66238653t__eam
tear45242883t__ear
teas45851493t__eas
teat45963633t__eat
temp85323333t__emp
tepa66021683t__epa
terai53525483ter_ai
teraph11319093ter_aph
teredo7310783teredo
terefah1344113terefah
terete6319333terete
terga63315643terga_
tergal72912833tergal
terra54419663terra_
terrae62915213terrae
terras63516973terras
thae76825563th__ae
than76128773th__an
that75639323th__at
thaw107521313th__aw
the67436053th_e__
thebe107515433th_ebe
theca103311453th_eca
thecae11299653thecae
thecal113310303thecal
thee78039063th_e_e
theft114118133th_eft
thegn95810903th_egn
thein85919023th_ein
their85512153th_eir
them97427043th_e_m
theme105921733th_eme
then78429693th_e_n
thenal92712423thenal
thenar92610003thenar
thens85921833th_ens
there87527393th_ere
thereby1534633thereby
therein102310353therein
thereof13168063thereof
thereon10199263thereon
theres96525473theres
thereto1038993thereto
theriac1239143theriac
therian10311293therian
therm106018023th_erm
thermae125310503thermae
thermal125010973thermal
therme115814993therme
therms115914873therms
these86519013th_ese
thesps11448263th_esps
theta83414573th_eta
thetas93011573thetas
thew108226233th_e_w
thews117416193th_ews
thewy146311853th_ewy
they107223753th_e_y
thief114516303thie_f
thieve1235963thieve
thiram1139963thiram
thorax1638253thorax
thoria93012893thoria_
thorias102312053thorias
thorp104414263th_orp
thrall93810293thrall
thrash12258363thrash
thrave126010273thrave
thrawn12769423thrawn
thraws129211103thraws
threaded1366323threaded
threader1256733threader
threapers1444773threapers
threaping15106113threaping
threated1259203threated
threaten1146303threaten
threeped1454373threeped
thrice114311573thrice
thrift12412043thrift
thrill94910593thrill
thrips11299013thrips
thrive125313223thrive
thro77726423thr__o
throats104612193throats
throaty13428483throaty
throb109816853thr_ob
throbs118311373throbs
throe89321423thr_oe
throes97518673throes
throne98517603throne
throng10539973throng
throve128012393throve
throw118719733thr_ow
thrown1214911443thrown
throws129715233throws
thru76818943thr__u
thrum104713633thr_um
thrums11429123thrums
thrush12257483thrush
thrust91911893thrust
thruway1643163thruway
thuja1535213thuja_
thujas1634433thujas
thump126211573th_ump
thuya1135583thuya_
thuyas1234773thuyas
tinea54923163tinea_
tineal66216163tineal
tineas64616483tineas
tire46143353tire__
tired65228903tire_d
tires55437493tire_s
toea46732333t_oea_
toeas55726423t_oeas
toecap1037323toecap
tora47545993tor_a_
torah87125273tor_ah
toras55540373tor_as
tore47359323tore__
torero6313203torero
tores55352673tore_s
torta55925353torta_
tortas64918253tortas
trad55630913t_r_ad
tram67034553t_r_am
tramp96319773t_ramp
traps75727483t_r_aps
trapt76433393t_r_apt
tray77632593t_r_ay
treads74817923t_reads
treats64821693t_reats
treaty94414353t_reaty
tree47745813t_re_e
treed65626733t_reed
treen55622753t_reen
trees55835763t_rees
tref77030993t_re_f
trefah1235093t_refah
trek86222313t_re_k
treks96016853t_reks
trend64817453t_rend
trepan82511673t_repan
tres46542903t_re_s
tress55423163t_ress
tret46653533t_re_t
trets55928023t_rets
trews86118893t_rews
trey77228793t_re_y
treys85018213t_reys
triac74116373t_riac
triad65217723t_riad
trial54926353t_rial
trip66830393t_r_ip
troak95213573t_roak
tromp95815803t_romp
troop76417533t_roop
trop66833303t_r_op
trump95615123t_rump
tuneup835203tuneup
turban8310483turban
tureen63312723tureen
turnip836593turnip
turnup835093turnup
tweak1257753t_weak
twerp10398413t_werp
tyre75428253tyre__
tyred95816433tyre_d
tyres84725233tyre_s
unread73412673unread
unreal64414453unreal
unthread1244603unthread
upheap13105213upheap
upleap10106843upleap
uprear8168793uprear
urea46528053_urea_
ureal56722683_ureal
ureas55826013_ureas
whap125119643wh__ap
wheal115716183wh_eal
wheat114924573wh_eat
wheep136214353wh_eep
whelp136012093wh_elp
whereas13448903whereas
whereat134311923whereat
wiretap12145723wiretap
wrap96821973_wr_ap
wreak125513273_wreak

Search took 6 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.373479064.3
2DLD Change Limit1127163344.97022679.3
3Display Results3343340.0933591.4
 (SQL Overall)1786913345.43632871.8
 
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.