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

204 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
tussars735925(None) 
hussars10326981hussars
tussahs10335111tussahs
tussar6369541tussar_
tussers74313561tussers
tussors7388771tussors
tussurs7356391tussurs
bursars94510892bursars
busbars1138152busbars
cussers94213402cussers
fussers104210812fussers
hussar9317282hussar_
pulsars9358912pulsars
quasars1646902quasars
tossers74713502tossers
trussers8348282trussers
tsars56717112t__sars
tuskers113710042tuskers
tussah9356232tussa_h
tussal6288322tussa_l
tussehs10395562tussehs
tusser64615832tusser_
tusses64921242tuss_es
tussis6379952tuss_is
tussles737832tussles
tussor6378232tussor_
tussore7317282tussore
tussores8316532tussores
tussur6357292tussur_
assais6711963_assais
assays977903_assays
bursar85413253bursar_
bursary12397583bursary
bursas85318273bursa_s
busbar1038453busbar_
bushers124018803bushers
buskers133414093buskers
busses85023383buss_es
bustard10389723bustard
bustards11308513bustards
busters94724133busters
caesars9410733caesars
costars94218013costars
cursers94317163cursers
cursors93910023cursors
cushats12288273cushats
cushaws15356293cushaws
cusser86016093cusser_
cusses84522773cuss_es
cussos84210003cuss_os
custard10389973custard
custards11338393custards
disbars10310323disbars
dossals8379293dossals
dossers84516233dossers
durbars1077973durbars
dusters84918363dusters
escars83913133_escars
eskars10357593_eskars
essays965653_essays
fossas94610703fossa_s
fulmars1246423fulmars
fusser94813773fusser_
fusses94920553fuss_es
gassers84714633gassers
gossans836783gossans
guars65021053gu__ars
guessers9174903guessers
guisard954203guisard
guisards1043603guisards
guitars8116863guitars
gushers113512513gushers
gussets837443gussets
gussies82813303gussies
hissers104112313hissers
huskers143510043huskers
hussies103213293hussies
instars7411133instars
justers143815733justers
kissers114211293kissers
kussos10336423kuss_os
lascars979013lascars
lessors73610523lessors
lumbars11289763lumbars
lunars65012813lu_nars
lusters73921443lusters
lyssas935443lyssa_s
massas85116463massa_s
messans92710463messans
missals93914423missals
missays124010253missays
mossers94116193mossers
muggars11316643muggars
muscats1138933muscats
musers84719103mu_sers
mushers124016443mushers
mussels9419843mussels
musses84624783muss_es
mustard10359533mustard
mustards11297883mustards
musters94522513musters
nursers74311833nursers
ousters74122793ousters
outsays102710403outsays
outsoars838853outsoars
outwars10912793outwars
passers94717753passers
pessary1246873pessary
pissers95014753pissers
pulsar8329363pulsar_
pulsers94213153pulsers
pursers93916093pursers
pushers123814503pushers
pusses84322843puss_es
pussies93615693pussies
quasar1536833quasar_
rushers103816103rushers
russets738163russets
sansars73313913sansars
sarsars73512143sarsars
scars75433533__scars
sears54744913__sears
soars54732513__soars
spars75431543__spars
stars55836573__stars
sudsers83310423sudsers
sugars7312423su_gars
susses64221053suss_es
talars66021683t_alars
tars46763953t___ars
tarsals72512603tarsals
tartars73313403tartars
taskbars1452993taskbars
tassels74510853tassels
tasses64826763tass_es
tassets75012773tassets
tassies74918933tassies
tasters74225643tasters
tatars64619793t_atars
tears55436463t__ears
teasers75317243teasers
tensors72712373tensors
teslas64212173tesla_s
tessera736333tessera
testers74124543testers
thenars10248523thenars
tissues737463tissues
tolars64817943t_olars
tosser64215663tosser_
tosses65225393toss_es
tossups964023tossups
trocars959043trocars
trusser74010263trusser_
trusses73813643truss_es
trusters83112263trusters
trustors8268913trustors
tsar47819803t__sar_
tuatara745513tuatara
tuataras844863tuataras
tubas75119583tu_ba_s
tubbers113411253tubbers
tubers85017033tu_bers
tuckers134014353tuckers
tufas85314383tu_fa_s
tufters10298353tufters
tuggers93711443tuggers
tumors8810613tu_mors
tumours976753tumours
tunas54224123tu_na_s
tundras857113tundras
tuners64417343tu_ners
turbans939563turbans
turbary1236383turbary
turgors836833turgors
turners73912893turners
tusches1237903tusches
tushery1335633tushery
tushes94319473tu_shes
tushies10312163tushies
tusker104212193tusker_
tusks94915533tu_s_ks
tusseh9448423tuss_eh
tussises835433tussises
tussive1035303tussive
tussle637143tuss_le
tussled835413tussled
tussock1343833tussock
tussocks1443333tussocks
tussuck1343213tussuck
tussucks1442433tussucks
tutelars844993tutelars
tutors6912333tu_tors
tuyers94612563tu_yers
tzars144914273t__zars
unbars82113033_unbars
unsays9399543_unsays
upsoars985413upsoars
users55817573_u_sers
ushers94415533_ushers
usuals637783_usuals
vassals1057953vassals
vulgars11306533vulgars
wusses93314893wuss_es
wussies103411083wussies

Search took 8 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 Filter1786911340270.470380193.6
2DLD Change Limit1340272047.28018410.3
3Display Results2042040.0802550.0
 (SQL Overall)1786912047.83022821.3
 
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.