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

240 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
wonts8762154(None) 
fonts86124751fonts
wants87932211wants
wonks124818341wonks
wons74942041won_s
wont75842501wont_
worts88631181worts
wots76342891wo_ts
ants47243472_ants
aunts55227632aunts
bents76033692bents
bints76130182bints
bionts8612392bionts
boats75635152boats
bolts76232112bolts
bonds86126842bonds
bones76446532bones
bongs87828422bongs
bonks116326462bonks
bonus75324322bonus
boots75837972boots
borts76735452borts
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
bunts75729802bunts
cants77036942cants
cents74730332cents
coats75634992coats
colts76633292colts
cones76457422cones
conks115525702conks
conns75024232conns
cons66057692con_s
conte76633202conte
contes84432912contes
conto76027172conto
contos84923232contos
conus76726532conus
coots75636842coots
costs77231142costs
cots68054842co_ts
counts84618272counts
cunts76125122cunts
dents65031802dents
dints67431312dints
doats65224882doats
doits66223672doits
dolts65626312dolts
donas65926472donas
dongs76525812dongs
dons56048702don_s
donuts7410582donuts
dots55647662do_ts
dunts65828412dunts
eons46638712eon_s
fonds95824822fonds
fons76943892fon_s
font77143752font_
foots85528282foots
forts86034452forts
founts94313382founts
fronts94415792fronts
gents65729612gents
goats65527302goats
gongs74921612gongs
gouts64826172gouts
hants86335402hants
hents87330742hents
hints87330622hints
holts85627912holts
hones88144492hones
hongs95126202hongs
honks125124522honks
hons77350782hon_s
hoots84830242hoots
hosts85526702hosts
hots78349322ho_ts
hunts86826172hunts
ions46737852ion_s
joints133811452joints
jolts125018882jolts
jones125028182jones
jots116336142jo_ts
knots95614722knots
konks84917112konks
lints57137192lints
lofts85518362lofts
longs65527062longs
loots55431422loots
lots47652092lo_ts
louts56330272louts
lunts55826902lunts
mints76834042mints
moats75827642moats
molts76032092molts
monas74732152monas
monks116123392monks
monos75930862monos
mons68152252mon_s
monte75829772monte
montes84226932montes
month104818422month
months113812932months
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
mounts84115072mounts
nonas55126652nonas
nones55639132nones
nonets64118702nonets
nowts86915852nowts
oats46554212_oats
ones46146532_ones
onos46229002_onos
ons36148512_on_s
onto46127662_onto
onus45826812_onus
oots46446442_oots
opts68124742_opts
orts46538332_orts
outs45746962_outs
owns76819582own_s
pants76536922pants
pints75936222pints
poets76024442poets
points85618532points
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602pon_s
pontes83627852pontes
ports75934592ports
posts75228782posts
pots66452362po_ts
pouts75530322pouts
punts75828002punts
rants55935342rants
rents55935182rents
roots55933672roots
rots46454092ro_ts
routs57133412routs
runts55927632runts
snots55225102snots
softs85019232softs
sones55444142sones
songs67725552songs
sons46049552son_s
soots55536202soots
sorts54536662sorts
sots45552442so_ts
swots85518422swo_ts
tents56434212tents
tints56030922tints
tofts84919242tofts
toits55327472toits
tones56048662tones
tongs65928462tongs
tons46553052ton_s
tonus56324302tonus
toots55331872toots
torts56138122torts
tots46654122to_ts
touts54830392touts
vents86125932vents
volts85421292volts
wafts116920552wafts
waits88333522waits
wands96425482wands
wanes85040882wanes
wanks126124482wanks
wans76452262wan_s
want76156162want_
warts814840402warts
wasts87433672wasts
wats77555882w_ats
watts86923092watts
weets85427722weets
wefts116715492wefts
welts85225192welts
wends95822812wends
wens76337932wen_s
went76051872went_
wests85727002wests
wets75940292w_ets
whats117718992whats
whets115019612whets
whits115923822whits
whorts125111432whorts
wilts85023502wilts
winds95425602winds
wines85546862wines
wings95727242wings
winks125325432winks
winos84625042winos
wins75949172win_s
wists86728522wists
wits76044872w_its
woads94818442woads
woes76440662wo_es
wogs86531402wo_gs
woks116224902wo_ks
wolds95420182wolds
wolfs116214162wolfs
wombs125813342wombs
won66252062won__
wonk116125302won_k
wonky154011772wonky
wonted103213282wonted
wonton93410962wonton
wontons103310532wontons
woods95723032woods
woofs114918002woofs
wools84421462wools
woops104917522woops
woos76238802wo_os
wops96634152wo_ps
words95425072words
works125621902works
worms105320752worms
worst86330132worst
worsts96014332worsts
wort76654752wort_
worth117120522worth
worths127812892worths
wos66953532wo__s
wost76544362wost_
wot610467482wo_t_
wounds103811632wounds
wows104633492wo_ws
writs86624382writs
wrongs10338932wrongs
wynds126310372wynds
wynns11517472wynns
wyns105717032wyn_s
yonis85020822yonis
zones145528042zones
zonks184815172zonks

Search took 2 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 Limit538002401.75030742.9
3Display Results2402400.0604000.0
 (SQL Overall)1786912401.92093068.2
 
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.