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

279 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
tussar636954(None) 
hussar9317281hussar
tussah9356231tussah
tussal6288321tussal
tussars7359251tussars
tusser64615831tusser
tussor6378231tussor
tussur6357291tussur
bursar85413252bursar
busbar1038452busbar
cusser86016092cusser
fusser94813772fusser
hussars10326982hussars
pulsar8329362pulsar
quasar1536832quasar
tosser64215662tosser
trusser74010262trusser
tsar47819802t__sar
tusker104212192tusker
tussahs10335112tussahs
tusseh9448422tusseh
tussers74313562tussers
tusses64921242tusses
tussis6379952tussis
tussle637142tussle
tussore7317282tussore
tussors7388772tussors
tussurs7356392tussurs
assai5711543_assai
assay8710283_assay
aurar54420253au_rar
bulbar1039583bulbar
bursa74921523bursa_
bursae84515603bursae
bursal84414823bursal
bursars94510893bursars
bursary12397583bursary
bursas85318273bursas
busbars1138153busbars
busher114922203busher
busier85219723busier
busker125517833busker
busman10310253busman
buss65134913buss__
bussed94717053bussed
busses85023383busses
bustard10389723bustard
buster84726493buster
byssal1134993byssal
caesar8410933caesar
costar85518613costar
curser84721473curser
cursor84110293cursor
cushat113513693cushat
cushaw14386983cushaw
cuspal1037883cuspal
cuss65430613cuss__
cussed94917123cussed
cussers94213403cussers
cusses84522773cusses
cusso74912293cuss_o
cussos84210003cussos
custard10389973custard
disbar938513disbar
dossal75510303dossal
dosser74417973dosser
durbar968723durbar
duster74919723duster
escar74011993_escar
eskar9457453_eskar
essay867623_essay
fossa85812633fossa_
fossae95510373fossae
fossas94610703fossas
fubar1039923fu_bar
fulmar1137253fulmar
fuss76027933fuss__
fussed104613803fussed
fussers104210813fussers
fusses94920553fusses
fussier103610673fussier
fussy115613953fuss_y
gasser75017773gasser
gossan747233gossan
guar56923293gu__ar
guesser8166543guesser
guisard954203guisard
guitar7117443guitar
gular6314833gu_lar
gusher104115773gusher
gusset7316433gusset
gussie72910153gussie
gussy95314323guss_y
hisser94713793hisser
husker134212703husker
hussy116812763huss_y
instar6310013instar
juster134617013juster
kisser104212453kisser
kusso9398033kuss_o
kussos10336423kussos
lascar868573lascar
lesser63514853lesser
lessor64010603lessor
lumbar103610593lumbar
lunar57017313lu_nar
lusher93818763lusher
luster64023673luster
lustra6358893lustra
lyssa835713lyssa_
lyssas935443lyssas
massa75518923massa_
massas85116463massas
messan83912063messan
missal84314903missal
missay114112143missay
mosser84618273mosser
muggar10316443muggar
musca9311763musca_
muscae10410673muscae
muscat10314653muscat
muser76024123mu_ser
musher113820573musher
muss64933763muss__
mussed94418903mussed
mussel83412903mussel
musses84624783musses
mussier93314363mussier
mussy104117643muss_y
mustard10359533mustard
muster84724523muster
nurser64314503nurser
osar46820953__osar
ossa43714163_ossa_
ouster64223733ouster
outsat62920283outsat
outsaw92610283outsaw
outsay92611873outsay
outsoar739493outsoar
outwar91011513outwar
passer84721033passer
pessary1246873pessary
pisser84416383pisser
pulsars9358913pulsars
pulser84215193pulser
purser85020473purser
pusher114318283pusher
puss64830133puss__
pusses84322843pusses
pussier93711993pussier
pussly11407373pussly
pussy105614843puss_y
quasars1646903quasars
rusher94019653rusher
russet6319433russet
sansar63613393sansar
sarsar63011843sarsar
scar66434203__scar
sear47353843__sear
soar46838673__soar
spar65433303__spar
star48037763__star
subpar1048663subpar
sudser73511283sudser
sugar6312913su_gar
suss45229303suss__
sussed75015533sussed
susses64221053susses
talar56225383t_alar
tar37570693t___ar
tarsal63315273tarsal
tartar63214753tartar
taskbar1393023taskbar
tass45640573tass__
tasse54821843tass_e
tassel66014773tassel
tasses64826763tasses
tasset65925313tasset
tassie66017023tassie
taster64930573taster
tatar56122063t_atar
tear45242883t__ear
teaser65421523teaser
tenser64919433tenser
tensor63812673tensor
terser67317823terser
tesla55612603tesla_
teslas64212173teslas
tessera736333tessera
testa54822043testa_
testae64216253testae
tester64227153tester
thenar92610003thenar
tissual745193tissual
tissue637333tissue
tissular843813tissular
tolar55524113t_olar
toss45637973toss__
tossed74215223tossed
tossers74713503tossers
tosses65225393tosses
tossup875293tossup
trocar848773trocar
truss54916923truss__
trussed84010033trussed
trussers8348283trussers
trusses73813643trusses
truster73114313truster
trustor7238413trustor
tsars56717113t__sars
tsuba745563tsuba_
tuatara745513tuatara
tuba65422363tu_ba_
tubae74716643tu_bae
tubal75517203tu_bal
tubas75119583tu_bas
tubber104313203tubber
tuber75420683tu_ber
tubs65430063tubs__
tubular9267473tubular
tucker124316953tucker
tufa75016613tu_fa_
tufas85314383tu_fas
tufter9319933tufter
tugger84013103tugger
tugs56231673tugs__
tuis44829643tuis__
tumor71110693tu_mor
tumour8137403tumour
tumular9236543tumular
tuna45127843tu_na_
tunas54224123tu_nas
tundra736423tundra
tuner56022683tu_ner
tuns45138663tuns__
tups65628763tups__
turban8310483turban
turbary1236383turbary
turgor736863turgor
turner63914613turner
tusche1136783tusche
tush74523903tu_s_h
tushed104615893tushed
tushery1335633tushery
tushes94319473tushes
tushie939723tushie
tushy114212993tu_shy
tusk85621633tu_s_k
tusked114112153tusked
tuskers113710043tuskers
tusks94915533tu_sks
tussehs10395563tussehs
tussive1035303tussive
tussled835413tussled
tussles737833tussles
tussock1343833tussock
tussores8316533tussores
tussuck1343213tussuck
tutelar735373tutelar
tutor5712493tu_tor
tuts45838453tuts__
tuyer85414293tu_yer
tzar136315373t__zar
ulnar56013983_ulnar
unbar71913613_unbar
unsay83212843_unsay
upsoar8105683upsoar
ursa44116913_ursa_
ursae55214453_ursae
user45023003_u_ser
usher84517763_usher
usual5310183_usual
vassal979243vassal
vulgar10426823vulgar
vulvar12427963vulvar
wuss75219333wuss__
wusses93314893wusses
wussier10408083wussier
wussy115810343wuss_y

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 Limit1127162795.48320557.4
3Display Results2792790.0933000.0
 (SQL Overall)1786912795.95230022.0
 
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.