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

166 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
tossup87529(None) 
tossups964021tossups
gossip946432gossip
possum1057952possum
tissue637332tissue
toss45637972toss__
tossed74215222tossed
tosser64215662tosser
tosses65225392tosses
tussur6357292tussur
bosque17257733bosque
boss65938343boss__
bossed94816533bossed
bosses85925403bosses
bossy105515973boss_y
bosun75113593bo_sun
byssus1133763byssus
catsup1036433catsup
closeup11113433closeup
cockup1635713cockup
consul82312303consul
coss66143493coss__
cosset84125863cosset
coup86729793co__up
dorsum947623dorsum
doss56235043doss__
dossal75510303dossal
dossed84516633dossed
dossel74813643dossel
dosser74417973dosser
dosses76126273dosses
dossil75110903dossil
dustup935363dustup
foldup1233813foldup
foss76431643foss__
fossa85812633foss_a
fossae95510373fossae
fossas94610703fossas
fosse86119463foss_e
fosses96022083fosses
fossil9379353fossil
gossan747233gossan
gossips1035903gossips
gossipy1343953gossipy
holdup1245183holdup
hookup1534423hookup
hyssop1443413hyssop
issue559213_issue
joss115925593joss__
josses135117683josses
koss85224813koss__
lockup1434763lockup
lookup1233453lookup
loss45337963loss__
losses65925233losses
lossy85214643loss_y
loup66028433lo__up
missus85312293missus
mockup1634073mockup
mosque17287163mosque
moss67641033moss__
mossed94818893mossed
mosser84618273mosser
mosses85527683mosses
mosso74715183moss_o
mossy105217063moss_y
opossum1153443opossum
ossa43714163_oss_a
ossia53710403_ossia
passus83610293passus
poseur8419403poseur
posse74722273poss_e
posses85128803posses
posset84923253posset
possums1145753possums
postop10511943postop
pushup1335273pushup
roup66627693ro__up
scup84822383__scup
soup66232913__soup
stoss54316343stoss__
stoup75517073sto__up
sup57041943___sup
takeup1234583takeup
tarsus6310513tarsus
tass45640573tass__
tasse54821843tass_e
tassel66014773tassel
tasses64826763tasses
tasset65925313tasset
tassie66017023tassie
teacup1036253teacup
thesp105410313thes_p
tissual745193tissual
tissued835583tissued
tissues737463tissues
tissuey1033663tissuey
tittup834203tittup
toast55831013toas_t
toasts65914993toasts
toasty9509563toasty
tocsin8311003tocsin
tods56141843tods__
toecap1037323toecap
toes46956443toes__
tofu76921333to_fu_
tofus86415423to_fus
togs57242433togs__
togue64816303to_gue
tolu45529153to_lu_
tolus55024483to_lus
toms68343493toms__
tongue7410093tongue
tons46553053tons__
tonsil6311873tonsil
tonsure758783tonsure
tonus56324303to_nus
top510560683to___p
topful1136543topful
tophus115210363tophus
tops66248123tops__
toque145113093to_que
torous64319033torous
torque15237673torque
tors46157383tors__
torse55833333tors_e
torses64727953torses
torsi57423363tors_i
torsk94915773tors_k
torsks10549123torsks
torso56922143tors_o
torsos64815733torsos
torus54329763to_rus
tosh74826813to_s_h
toshes94520103toshes
tossers74713503tossers
tossing83612563tossing
tosspot966883tosspot
tost48351923to_s_t
tots46654123tots__
touchup1443833touchup
tour45530383to__ur
touse55430673tous_e
toused74122013toused
touses64229673touses
tousle64514653tousle
tout46753823to__ut
tows78545553tows__
toys78036343toys__
toyshop1544873toyshop
tuneup835203tuneup
tup56037543t___up
turnup835093turnup
tussah9356233tussah
tussal6288323tussal
tussar6369543tussar
tusseh9448423tusseh
tusser64615833tusser
tusses64921243tusses
tussis6379953tussis
tussle637143tussle
tussor6378233tussor
tussuck1343213tussuck
tussurs7356393tussurs
washup1435323washup
workup1534323workup

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.360496363.9
2DLD Change Limit1127161664.98322620.1
3Display Results1661660.0632634.9
 (SQL Overall)1786911665.40633054.2
 
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.