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 “thus” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

213 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
thus7672147(None) 
rhus75114051rhus
taus46342731taus
this76027381this
thous86017261thous
thud85613911thud
thuds95110131thuds
thug86415481thug
thugs95611991thugs
ahis76135382ahis
ahs68644822ah_s
amus65529612amus
anus47131112anus
bhut95425712bhut
bhuts105812952bhuts
bus56950972_bus
chis95933312chis
chub115516412chub
chubs125412622chubs
chug105914112chug
chugs115511942chugs
chum116318002chum
chums125015832chums
crus65828482crus
ecus65421462ecus
emus66821682emus
ethos85514192ethos
eths76619522eth_s
feus75830752feus
flus75626542flus
ghis85020162ghis
gnus56518002gnus
has67372652_has
hes66654202_hes
his66359512_his
hos68364192_hos
hub86437482_hub
hubs96027142_hubs
hue66642302_hue
hues75235232_hues
hug76037362_hug
hugs86129752_hugs
huh96432012_huh
hum85542932_hum
hums96831422_hums
hun65844712_hun
huns76136932_huns
hup86437812_hup
hush105224112_hush
husk116021952_husk
hut66457292_hut
huts76737442_huts
jehus15488572jehus
jus106930222_jus
khis117017992khis
mhos95517772mhos
mus55946752_mus
nous46136982nous
nus37939392_nus
ohms95514032ohms
ohs66232312oh_s
onus45826812onus
opus66420592opus
phis95724902phis
phut96925972phut
phuts104613502phuts
plus66324832plus
pus55547842_pus
rhos76319062rhos
shes75734352shes
shul75823152shul
shuls85319712shuls
shun75122772shun
shuns85018142shuns
shush113812542shush
shut76137592shut
shuts85622482shuts
sous46947212sous
tabs66842982tabs
tabus74820922tabus
tads57143952tads
tags55545242tags
tahrs85412332tahrs
talus55423262talus
tams67247932tams
tans46154832tans
taos45541002taos
taps66050682taps
tars46763952tars
tas38477102t_as
tass45640572tass
tats46858132tats
tau36856902tau_
taut47048962taut
tauts56125512tauts
tavs75630972tavs
taws75641592taws
taxus125512482taxus
teas45851492teas
teds54932582teds
tees45353582tees
tegs56031492tegs
tels46841692tels
tens45647412tens
tets45847462tets
tews76431642tews
thae76825562thae
than76128772than
that75639322that
thaw107521312thaw
thaws116515462thaws
the67436052th_e
thee78039062thee
them97427042them
then78429692then
thens85921832thens
these86519012these
thesp105410312thesp
thew108226232thew
thews117416192thews
they107223752they
thin76732392thin
thins85826332thins
thio77225412thio
thir76420542thir
tho67433962th_o
those85218142those
thou76722212thou
thro77726422thro
thru76818942thru
thrum104713632thrum
thrums11429122thrums
thrush12257482thrush
thrust91911892thrust
thuja1535212thuja
thujas1634432thujas
thumb124511282thumb
thumbs13377442thumbs
thump126211572thump
thumps13449352thumps
thunk124911852thunk
thunks13459032thunks
thurl84912682thurl
thurls9418712thurls
thusly1235132thusly
thuya1135582thuya
thuyas1234772thuyas
thy97022912th_y
thymus14324742thymus
tics65729642tics
ties45248322ties
tils45739622tils
tins45251312tins
tips66436772tips
tis37056652t_is
tits46145052tits
tods56141852tods
toes46956442toes
tofus86415422tofus
togs57242432togs
tolus55024482tolus
toms68343492toms
tons46553052tons
tonus56324302tonus
tophus115210362tophus
tops66248122tops
tors46157382tors
torus54329762torus
toss45637972toss
tots46654122tots
tour45530382tour
tours55325892tours
touse55430672touse
tout46753822tout
touts54830392touts
tows78545552tows
toys78036342toys
tres46542902tres
true46725852true
trues54925322trues
trug55720042trug
trugs65516802trugs
truss54916922truss
trust55426852trust
tsks86410662tsks
tub55640032t_ub
tubs65430062tubs
tug45937402t_ug
tugs56231672tugs
tui37034022t_ui
tuis44829642tuis
tun35845192t_un
tuns45138662tuns
tup56037542t_up
tups65628762tups
tush74523902t_ush
tusk85621632t_usk
tut36758092t_ut
tuts45838452tuts
tutus55214812tutus
tux105426572t_ux
twas76824082twas
twos76718022twos
tyes76433372tyes
typhus14395712typhus
ulus45622562ulus
urus46426142urus
us26937432__us
vaus75928922vaus
whup125714162whup
whups134210002whups
whys137011662whys
yous76230652yous

Search took 2 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 Filter178691298720.326548131.9
2DLD Change Limit298722130.89033564.0
3Display Results2132130.0464630.4
 (SQL Overall)1786912131.262141593.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.