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

257 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
hussar931728(None) 
hussars10326971hussars
tussar6369541tussar
bursar85413252bursar
busbar1038452busbar
cusser86016092cusser
fusser94813772fusser
hisser94713792hisser
husker134212702husker
hussy116812762huss_y
pulsar8329362pulsar
quasar1536832quasar
tussah9356232tussah
tussal6288322tussal
tussars7359242tussars
tusser64615832tusser
tussor6378232tussor
tussur6357292tussur
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
chuddar14263963chuddar
chukar1534633chu_kar
chukkar1542053chukkar
costar85518613costar
curser84721473curser
cursor84110293cursor
cushat113513693cushat
cushaw14386983cushaw
cuspal1037883cuspal
cuss65430613cuss__
cussed94917123cussed
cussers94213393cussers
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
haar77323493h__aar
hangar104114503hangar
hansa85416783hansa_
hansas94616043hansas
hassel95614213hassel
hassle93711593hassle
hawser125910843hawser
hear76143883h__ear
hessian1035853hessian
hilar85418143h_ilar
hiss75629213hiss__
hissed104114453hissed
hissers104112313hissers
hisses94719353hisses
hissier103410503hissier
hissy116112123hiss_y
hoar76729163h__oar
hoser811529763h_oser
hosier94219613hosier
hosta85917833hosta_
hostas94515823hostas
houser95322283houser
housesat1146473housesat
hubcap1553993hubcap
hubs96027143hubs__
hues75235233hues__
huger94914873hu_ger
hugger114713123hugger
hugs86129753hugs__
hula74923753hu_la_
hulas84920883hu_las
huller93919103huller
human102716033hu_man
hummer133615273hummer
humor101110513hu_mor
humour11116753humour
humper134115883humper
hums96831423hums__
hunger104015203hunger
hunker133917673hunker
huns76136933huns__
hunter94817773hunter
huppah1644183huppah
hurler94717223hurler
hurrah12369183hurrah
hurray12459913hurray
hurst85527193hurs_t
hursts97213093hursts
hurter93915853hurter
husband1345653husband
hush105224113hu_s_h
hushaby1842713hushaby
hushed134416673hushed
hushes124718593hushes
husk116021953hu_s_k
husked144212223husked
huskers143510033huskers
huskier14369753huskier
husks125015453hu_sks
husky156112563hu_sky
hussies103213293hussies
hustle93113993hustle
hustler103410753hustler
huts76737443huts__
huzza1646093huzza_
huzzah2044423huzzah
huzzas1735863huzzas
hyssop1443413hyssop
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
mussier93314353mussier
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
schusser1342973schusser
sear47353843__sear
shusher13288113shusher
soar46838673__soar
spar65433303__spar
star48037763__star
subpar1048663subpar
sudser73511283sudser
sugar6312913su_gar
suss45229303suss__
sussed75015533sussed
susses64221053susses
tosser64215663tosser
trusser74010253trusser
tsar47819803__tsar
tusker104212193tusker
tussahs10335113tussahs
tusseh9448423tusseh
tussers74313563tussers
tusses64921243tusses
tussis6379953tussis
tussle637143tussle
tussore7317283tussore
tussors7388763tussors
tussurs7356373tussurs
ulnar56013983_ulnar
unbar71913613_unbar
unsay83212843_unsay
upsoar8105683upsoar
ursa44116903_ursa_
ursae55214453_ursae
user45023003_u_ser
usher84517763_usher
usual5310183_usual
vassal979243vassal
vulgar10426823vulgar
vulvar12427963vulvar
wuss75219333wuss__
wusses93314893wusses
wussier10408083wussier
wussy115810343wuss_y

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.1561145455.1
2DLD Change Limit1127162576.12318408.6
3Display Results2572570.0962677.1
 (SQL Overall)1786912576.37528030.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.