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

163 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
nowts8691586(None) 
newts86015281newts
nows75738231now_s
nowt78833751nowt_
boats75635152boats
bolts76232112bolts
boots75837972boots
borts76735452borts
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
bowls106121432bowls
bows96242862bow_s
coats75635002coats
colts76633292colts
coots75636842coots
costs77231142costs
cots68054842co_ts
cowls106922212cowls
cows97046642cow_s
dawts97216122dawts
doats65224882doats
doits66223672doits
dolts65626312dolts
dots55647662do_ts
downs94918572downs
dows85941052dow_s
enows85115492enow_s
fonts86124752fonts
foots85528282foots
forts86034452forts
fowls115518892fowls
goats65527302goats
gouts64826172gouts
gowds105814042gowds
gowks136011952gowks
gowns95115102gowns
holts85627912holts
hoots84830252hoots
hosts85526702hosts
hots78349332ho_ts
howes114730262howes
howfs144814502howfs
howks155016852howks
howls116219222howls
hows106345602how_s
jolts125018882jolts
jots116336142jo_ts
jowls156214522jowls
jows146632092jow_s
knots95614722kno_ts
knouts10438312knouts
knowns13426442knowns
knows124912412know_s
lofts85518362lofts
loots55431422loots
lots47652092lo_ts
louts56330272louts
lowes85732462lowes
lows75843012low_s
moats75827642moats
molts76032092molts
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
mows96340832mow_s
neats55931902neats
nerts55924982nerts
nests55728002nests
nets45941532n_ets
netts55320722netts
news76127372new_s
newt76933742newt_
nits45741642n_its
nobs66436902no_bs
nocks115121012nocks
nodes64633492nodes
nods55838222no_ds
nodus66315992nodus
noels56418702noels
noes45845392no_es
noggs75811182noggs
nogs56534612no_gs
noils55024332noils
noirs55615462noirs
nolos54423352nolos
nomas74726412nomas
nomes74933122nomes
nomos75919742nomos
noms65636402no_ms
nonas55126652nonas
nones55639132nones
nonets64118702nonets
nooks95420392nooks
noons54125282noons
noris54928272noris
norms76019312norms
north86018272north
norths96812322norths
nos38859322no__s
noses55435642noses
not39474662no_t_
nota46830772no_ta
note46239962no_te
notes55034582notes
nouns56717312nouns
nous46136982no_us
novas85215362novas
now65950192now__
noway111112842noway
noways12127732noways
nowise9511072nowise
nuts45032672n_uts
oats46554212_oats
oots46446442_oots
opts68124742_opts
orts46538332_orts
outs45746962_outs
owes75137102_owes
owls76022932_owls
owns76819582_owns
poets76024442poets
ports75934592ports
posts75228782posts
pots66452362po_ts
pouts75530322pouts
pows95537662pow_s
roots55933672roots
rots46454092ro_ts
routs57133412routs
rows75941752row_s
rowth115713232rowth
rowths12458172rowths
snoots64216682snoots
snorts64116502snorts
snots55225122sno_ts
snouts64915872snouts
snows84719892snow_s
softs85019232softs
soots55536212soots
sorts54536662sorts
sots45552452so_ts
sows75342492sow_s
swots85518432swots
tofts84919242tofts
toits55327472toits
toots55331872toots
torts56138122torts
tots46654122to_ts
touts54830392touts
towns86018882towns
tows78545552tow_s
volts85421292volts
vows106626942vow_s
wonts87621542wonts
worts88631182worts
wots76342892wo_ts
wows104633492wow_s
yowes114926372yowes
yowls115715432yowls
yows106433122yow_s

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.313570897.8
2DLD Change Limit538001631.39038705.0
3Display Results1631630.0463543.5
 (SQL Overall)1786911631.749102167.5
 
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.