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 “tonus” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

191 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
tonus5632430(None) 
bonus75324321bonus
conus76726531conus
onus45826811_onus
tofus86415421tofus
tolus55024481tolus
tones56048661tones
tongs65928461tongs
tons46553051ton_s
torus54329761torus
anus47131112_anus
atones65225772atones
bogus85616472bogus
bolus79125542bolus
bonds86126842bonds
bones76446532bones
bongs87828422bongs
bonks116326462bonks
clonus85212412clonus
cones76457422cones
conks115525702conks
conns75024232conns
cons66057692con_s
cornus84816562cornus
donas65926472donas
dongs76525812dongs
dons56048702don_s
donut6324512donut
donuts7410582donuts
eons46638712eon_s
focus105815882focus
fonds95824822fonds
fondus105210942fondus
fons76943892fon_s
fonts86124752fonts
genus65319832genus
gnus56518002_gnus
gongs74921612gongs
hocus104715202hocus
hones88144492hones
hongs95126202hongs
honks125124522honks
hons77350782hon_s
ions46737852ion_s
jones125028182jones
konks84917112konks
locus74819992locus
longs65527062longs
lotus55718062lotus
manus75924922manus
menus75822842menus
minus75223932minus
modus85417202modus
momus96116112momus
monas74732152monas
monks116123392monks
monos75930862monos
mons68152252mon_s
nodus66315992nodus
nonas55126652nonas
nones55639132nones
nonuse63212252nonuse
nouns56717312nouns
nous46136982no_us
nus37939392__nus
ones46146532_ones
onos46229002_onos
ons36148512_on_s
opus66420592_opus
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602pon_s
sinus55523852sinus
solus54726982solus
sones55444142sones
songs67725552songs
sons46049552son_s
sorus54527582sorus
sous46947212so_us
stones65130032stones
tabus74820922tabus
talus55423262talus
tangs65028342tangs
tanks94624732tanks
tans46154812tan_s
taus46342732t_aus
taxus125512482taxus
tends65425582tends
tendus75111182tendus
tens45647412ten_s
tents56434212tents
tenues63816442tenues
tenuis64213082tenuis
thongs104611182thongs
thous86017252thous
thus76721472t_hus
tines54848422tines
tings65329192tings
tins45251302tin_s
tints56030922tints
toads65621062toads
tods56141842to_ds
toeas55726422toeas
toes46956442to_es
toffs116016722toffs
tofts84919242tofts
tofu76921332tofu_
togas67823002togas
togs57242432to_gs
togue64816302togue
togues76014242togues
toils54527492toils
toits55327472toits
tokes95234972tokes
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolu45529152tolu_
tombs97818732tombs
tomes76037382tomes
toms68343492to_ms
ton310265102ton__
tonal53724302tonal
tondi65716142tondi
tondo69718682tondo
tondos75115912tondos
tone46953742ton_e
toned65435342toned
toner55336242toner
toners64128002toners
toney86027412toney
tong56434352ton_g
tonga65619682tonga
tongas74315512tongas
tongue7410092tongue
tongues879692tongues
tonic74727652tonic
tonics83617862tonics
tonish93415902tonish
tonne54921432tonne
tonnes65320852tonnes
tonuses73612192tonuses
tony75635152ton_y
tools55325242tools
toons55027532toons
toots55331872toots
topes76941762topes
tophs105220052tophs
tophus115210362tophus
topis76025832topis
topos75726392topos
tops66248122to_ps
toque145113092toque
toques154612352toques
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torous64319022torous
torrs53923562torrs
tors46157382to_rs
torts56138122torts
toss45637972to_ss
totes55139682totes
tots46654122to_ts
tour45530372to_ur
tours55325862tours
touse55430672to_use
tout46753822to_ut
touts54830392touts
towns86018882towns
tows78545552to_ws
toyos87519142toyos
toys78036342to_ys
tronas63816892tronas
trones65629282trones
tunas54224122tunas
tunes55332192tunes
tungs65520622tungs
tuns45138662tun_s
tutus55214812tutus
tynes85920302tynes
venus84918902venus
wonks124818342wonks
wons74942042won_s
wonts87621542wonts
yonis85020822yonis
yous76230652yo_us
zones145528042zones
zonks184815172zonks

Search took 3 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 Filter178691538000.1101624463.6
2DLD Change Limit538001911.90628226.7
3Display Results1911910.0464152.2
 (SQL Overall)1786911912.06286659.1
 
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.