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

291 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
thrush1225748(None) 
thrash12258361thrash
thresh12276861thresh
thrust91911891thrust
brush105917472_brush
choush14549062choush
crush106815992_crush
hush105224112_h_ush
inrush936512inrush
onrush935342onrush
qurush1835502qurush
rush76628182__rush
shush113812542sh_ush
tarbush1234172tarbush
though139410772though
thous86017262thous_
through141647512through
thru76818942thru__
thrum104713632thru_m
thrums11429122thrums
thrushes1436522thrushes
thrusts10226522thrusts
thus76721472th_us_
torus54329762torus_
trash86119762t_rash
truss54916922t_russ
trust55426852t_rust
truth85214152t_ruth
tush74523902t__ush
uprush1135782uprush
ablush1147223ablush
afresh1255503afresh
ambush1336113ambush
ankush13114433ankush
blush105115313_blush
brash106221563_brash
brugh115414293_brugh
brushy14468263_brushy
brusk114912433_brusk
bulrush1243593bulrush
bush96630713__bush
ceruse83914523ceruse
cherish15310463cherish
chirus114615693chirus_
chorus115014773chorus_
chough15699243chough
chouse116017563chouse
chrism13710673chrism
church1636483church
crash109120013_crash
crus65828483_crus_
cruse75726103_cruse
crust75827663_crust
druse64817663_druse
ecrus75113863ecrus_
etherish1448273etherish
flush115116073_flush
fresh115012203_fresh
frosh115713403_frosh
garish104516923garish
girsh95310023gir_sh
gursh94512333gur_sh
gurus64318193gurus_
gush85424003__gush
gyrus95310803gyrus_
harsh116418053_harsh
hash106936503_h_ash
haugh125114053_haugh
heuch135312333_heuch
heugh125410923_heugh
house89131423_house
huh96432013_h_u_h
hunh106323733_h_unh
hurst85527193_hurst
husk116021953_h_usk
kurus98015633kurus_
lush75327693__lush
marish114319053marish
marsh105320853mar_sh
mush94929123__mush
ogrish1039263ogrish
outrush1037043outrush
parish115022353parish
perish114619063perish
peruse84016843peruse
phrase11109903phrase
plush105614713_plush
push95526623__push
qursh174110843qur_sh
rash76039933__rash
resh76523453__resh
rhus75114053rh_us_
ruse45938933__ruse
rushy115414813__rushy
rusk85823313__rusk
rust45544913__rust
ruth76825993__ruth
shaugh13287433shaugh
sheesh1237813sheesh
sheuch14267043sheuch
sheugh13295883sheugh
shris84221453shris_
shrub104814893shru_b
shrubs11409213shrubs
shrug94512513shru_g
shrugs10469163shrugs
shrunk13357063shrunk
slush85316573_slush
smush104410583_smush
sorus54527583sorus_
squush1833993squush
tabus74820923tabus_
tahrs85412333tahr_s_
talus55423263talus_
tares57456563tares_
tarnish101611873tarnish
tarns56433953tarns_
taros55640823taros_
tarps76527113tarps_
tars46763953tar_s_
tarsi55222173tar_si
tarsus6310513tarsus
tartish101512633tartish
tarts57242023tarts_
taus46342733t_aus_
taxus125512483taxus_
teraph11319093teraph
terms75523473terms_
terns55226873terns_
terse55026823ter_se
teuch105214853t_euch
teugh95511613t_eugh
tharms115712243tharms_
thatch1435613thatch
thaws116515463thaws_
theism1139483theism
theist9314763theist
thens85921833thens_
theres96525473theres_
therms115914873therms_
these86519013th_ese
thesp105410313th_esp
thews117416193thews_
thigh12410123th_igh
thighs1346633thighs
thins85826333thins_
thirds10438603thirds_
thirls95012063thirls_
thirst9312253thirst
this76027383th_is_
thornbush1751213thornbush
thorns95314103thorns_
thorough15684123thorough
thorps113610893thorps_
those85218143th_ose
thou76722213thou__
thoued10429003thoued
thought14639133thought
thrall93810293thrall
thrashed1555363thrashed
thrasher1455743thrasher
thrashes1487653thrashes
thrave126010273thrave
thraw1110515923thr_aw
thrawn12769423thrawn
thraws129211103thraws
thread105011093thread
threap11569663threap
threat95020463threat
three87526913thr_ee
threep115910113threep
threes97117323threes
threshed1535643threshed
thresher1455823thresher
threshes1437383threshes
threw1117315713thr_ew
thrice114311573thrice
thrift12412043thrift
thrill94910593thrill
thrip103012183thr_ip
thrips11299013thrips
thrive125313223thrive
thro77726423thr__o
throat94819753throat
throb109816853thr_ob
throbs118311373throbs
throe89321423thr_oe
throes97518673throes
throne98517603throne
throng10539973throng
throve128012393throve
throw118719733thr_ow
thrown1214911443thrown
throws129715233throws
thrummy1742173thrummy
thruput1243863thruput
thrusted1265223thrusted
thruster1135793thruster
thrustor1144123thrustor
thruway1643163thruway
thud85613913th_u_d
thuds95110133th_uds
thug86415483th_u_g
thugs95611993th_ugs
thuja1535213th_uja
thumb124511283th_umb
thump126211573th_ump
thunk124911853th_unk
thurl84912683th_url
thurls9418713thurls
thusly1235133th_usly
thuya1135583th_uya
thymus14324743thymus_
thyrse1235133thyrse
thyrsi1234453thyrsi
thyrsus1342693thyrsus
tigrish1137573tigrish
tires55437493tires_
tirls54519803tirls_
tiros54524893tiros_
tofus86415423tofus_
tolus55024483tolus_
tonish93415903tonish
tonus56324303tonus_
torah87125273tor_ah
torahs95115643torahs
toras55540373toras_
torch107420933tor_ch
torcs75123763torcs_
tores55352673tores_
toros54336193toros_
torose64317693torose
toroth95512963toroth
torous64319033torous_
torrs53923563torrs_
tors46157383tor_s_
torse55833333tor_se
torsi57423363tor_si
torsk94915773tor_sk
torso56922143tor_so
torts56138123torts_
torula6610393torula
tosh74826813t__osh
touch106519393t_ouch
tough97321983t_ough
tours55325893tours_
touse55430673t_ouse
toyish122911123toyish
trashy12509053t_rashy
trass56226473t_rass
tres46542903t_res_
tress55423163t_ress
troth85622203t_roth
trough108512023trough
truce75118693t_ruce
truck116115463t_ruck
true46725853t_ru_e
trued65117693t_rued
truer54916643t_ruer
trues54925323t_rues
truest64816193t_ruest
trug55720043t_ru_g
trugs65516803t_rugs
truism8118623t_ruism
trull54012673t_rull
truly84111553t_ruly
trump95615123t_rump
trunk94713043t_runk
trusts64714433t_rusts
trusty94710113t_rusty
truths9449503t_ruths
tryst84716223t_ryst
turds65021693turds_
turfs84620443turfs_
turks95320823turks_
turns55623233turns_
turps74918733turps_
tushy114212993t__ushy
tusk85621633t__usk
tutus55214813tutus_
tyres84725233tyres_
tyros85118593tyros_
upthrust1343713upthrust
urus46426133_urus_
uterus639203uterus_
varus85921183varus_
virus85316843virus_
whish144512923wh_ish
whoosh15244353whoosh
whorish1636603whorish
xerus12313333xerus_

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.376475242.0
2DLD Change Limit1127162915.25021469.7
3Display Results2912910.0933129.0
 (SQL Overall)1786912915.71931245.1
 
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.