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

222 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
tussur635729(None) 
tussar6369541tussar
tusser64615831tusser
tussor6378231tussor
tussurs7356371tussurs
cusser86016092cusser
fusser94813772fusser
hussar9317282hussar
tissue637332tissue
tosser64215662tosser
tossup875292tossup
trusser74010252trusser
tumour8137392tumour
tusker104212192tusker
tussah9356232tussah
tussal6288322tussal
tussars7359242tussars
tusseh9448422tusseh
tussers74313562tussers
tusses64921242tusses
tussis6379952tussis
tussle637142tussle
tussore7317282tussore
tussors7388762tussors
tussuck1343212tussuck
assure6610773_assure
augur64311213au_gur
auteur6107943auteur
bulgur9387533bulgur
bursar85413253bursar
busbar1038453busbar
busher114922203busher
busier85219723busier
busker125517833busker
buss65134913buss__
bussed94717053bussed
busses85023383busses
buster84726493buster
byssus1133763byssus
curser84721473curser
cursor84110293cursor
cuscus1038113cuscus
cuss65430613cuss__
cussed94917123cussed
cussers94213393cussers
cusses84522773cusses
cusso74912293cuss_o
cussos84210003cussos
diseur738843diseur
dosser74417973dosser
duster74919723duster
dustup935363dustup
fissure1036783fissure
furfur1235553furfur
fuss76027933fuss__
fussed104613803fussed
fussers104210813fussers
fusses94920553fusses
fussier103610673fussier
fussy115613953fuss_y
gasser75017773gasser
guesser8166543guesser
gusher104115773gusher
gusset7316433gusset
gussie72910153gussie
gussy95314323guss_y
hisser94713793hisser
humour11116753humour
husker134212703husker
hussars10326973hussars
hussy116812763huss_y
issue559213_issue
issuer646623_issuer
juster134617013juster
kisser104212453kisser
kultur1034433kultur
kusso9398033kuss_o
kussos10336423kussos
lesser63514853lesser
lessor64010603lessor
lusher93818763lusher
luster64023673luster
lusus54813873lu_sus
masseur935703masseur
missus85312293missus
mosser84618273mosser
muggur10325593muggur
murmur1034853murmur
muser76024123mu_ser
museum1037703museum
musher113820573musher
muss64933763muss__
mussed94418903mussed
mussel83412903mussel
musses84624783musses
mussier93314353mussier
mussy104117643muss_y
muster84724523muster
nurser64314503nurser
ouster64223733ouster
passer84721033passer
passus83610293passus
pisser84416383pisser
poseur8419403poseur
possum1057953possum
pulsar8329363pulsar
pulser84215193pulser
purser85020473purser
pursue84512253pursue
pursuer9338893pursuer
pusher114318283pusher
pushup1335273pushup
puss64830133puss__
pusses84322843pusses
pussier93711993pussier
pussly11407373pussly
pussy105614843puss_y
quasar1536833quasar
rumour8127373rumour
rusher94019653rusher
russet6319433russet
slur45525153__slur
sour45935893__sour
spur65321193__spur
sudser73511283sudser
sulfur937913sulfur
suss45229303suss__
sussed75015533sussed
susses64221053susses
tabour84011313tabour
tambur10358713tambur
tarsus6310513tarsus
tass45640573tass__
tasse54821843tass_e
tassel66014773tassel
tasses64826763tasses
tasset65925313tasset
tassie66017023tassie
taster64930573taster
teaser65421523teaser
tenour62610733tenour
tenser64919433tenser
tensor63812673tensor
terser67317823terser
tessera736333tessera
tester64227153tester
tissual745193tissual
tissued835583tissued
tissues737463tissues
tissuey1033663tissuey
tissular843813tissular
tonsure758783tonsure
toss45637973toss__
tossed74215223tossed
tossers74713493tossers
tosses65225393tosses
tossups964013tossups
tour45530373t__our
tressour844563tressour
tressure846483tressure
truss54916923truss__
trussed84010013trussed
trussers8348263trussers
trusses73813633trusses
truster73114313truster
trustor7238403trustor
tsar47819803t__sar
tubber104313203tubber
tuber75420683tu_ber
tubful1136683tubful
tubs65430063tubs__
tuchun1145443tuchun
tucker124316953tucker
tufter9319933tufter
tugger84013103tugger
tugs56231673tugs__
tuis44829643tuis__
tumor71110693tu_mor
tumours976733tumours
tuner56022683tu_ner
tuneup835203tuneup
tuns45138663tuns__
tups65628763tups__
tuque14469193tu_que
turgor736863turgor
turner63914613turner
turnup835093turnup
tusche1136783tusche
tush74523903tu_s_h
tushed104615893tushed
tushery1335633tushery
tushes94319473tushes
tushie939723tushie
tushy114212993tu_shy
tusk85621633tu_s_k
tusked114112153tusked
tuskers113710033tuskers
tusks94915533tu_sks
tussahs10335113tussahs
tussehs10395563tussehs
tussive1035303tussive
tussled835413tussled
tussles737833tussles
tussock1343833tussock
tussores8316533tussores
tussucks1442433tussucks
tutor5712493tu_tor
tuts45838453tuts__
tutu48423173tu_tu_
tutus55214813tu_tus
tuyer85414293tu_yer
unsure62815413_unsure
user45023003_u_ser
usher84517763_usher
usque14137733_usque
usurp7106903_u_surp
usury887623_u_sury
wushu1136993wushu_
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.1401276364.3
2DLD Change Limit1127162226.23618075.0
3Display Results2222220.0762921.1
 (SQL Overall)1786912226.45227695.4
 
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.