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

318 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
coons7673728(None) 
boons75031911boons
cions75222851cions
clons75228131clons
codons96119461codons
cogons96818111cogons
coins75834551coins
colons86028671colons
conns75024231conns
cons66057691c_ons
coofs105924711coofs
cooks115429141cooks
cools75632631cools
coon67248941coon_
coops96229641coops
coos67456491coo_s
coots75636841coots
corns76034761corns
croons85418421croons
goons65326771goons
loons55731721loons
moons75331001moons
noons54125281noons
poons75430961poons
toons55027531toons
zoons144919691zoons
acorns85013012acorns
aeons57624652aeons
agons66423782agons
axons125517932axons
azons146518252azons
boobs96221992boobs
books115729712books
booms95427122booms
boon67142172boon_
boors74325012boors
boos67955032boo_s
boots75837972boots
borons85520542borons
bosons85016652bosons
cains75334302cains
canons85522062canons
cans65050842c_ans
capons104119502capons
carns75937562carns
chins105631462chins
chon96627792chon_
chooks155312792chooks
chops125019872chops
chows135618202chows
cion613330912cion_
clans75031012clans
clods85320862clods
clogs85519552clogs
clon66232482clon_
clone75728162clone
clones84526562clones
clonk114417442clonk
clonks125013472clonks
clonus85212402clonus
cloots85113692cloots
clops95924852clops
clots75627642clots
clowns114810112clowns
cloys104916942cloys
coals76129602coals
coats75634992coats
cobbs115013982cobbs
cobs87043142c_obs
cocas95926572cocas
cocks135227162cocks
cocoas104915742cocoas
cocoons11310562cocoons
cocos95624692cocos
codas84724242codas
codens94821012codens
codes86247292codes
codon86522852codon_
cods76848102c_ods
coeds85920162coeds
coffs134916302coffs
cogon89120902cogon_
cogs77340032c_ogs
cohogs125810272cohogs
cohos105921852cohos
coifs105718702coifs
coigns94410062coigns
coils75030082coils
coin66645352coin_
coirs75221052coirs
cojoins1638992cojoins
cojones163512102cojones
cokes115537192cokes
colas75436772colas
colds85726972colds
coles76055062coles
colins85229042colins
cologs96517352cologs
colon78630192colon_
colone85425002colone
colones96124422colones
coloni85619202coloni
colonus94413432colonus
colony115417262colony
colors86622372colors
cols66553082c_ols
colts76633292colts
comas95833002comas
combs116122962combs
comes97246992comes
commons13311042commons
comous10816492comous
comps115526052comps
con510268022c_on_
cone67256962c_one
cones76457422cones
coni65534802c_oni
conins84327232conins
conk106531442c_onk
conks115525702conks
conn66229132c_onn
conus76726532conus
cony96537832c_ony
coo59566362coo__
cooch124916832cooch
cooed84534342cooed
cooee74531022cooee
cooees85621892cooees
cooer74831012cooer
cooers84324562cooers
cooey105828222cooey
cooeys114914482cooeys
coof96643272coo_f
cooing94024912cooing
cook107236932coo_k
cooky145321362cooky
cool66940492coo_l
cooly105525422cooly
coomb115615702coomb
coombs124210192coombs
coop87238652coo_p
coopt95929852coopt
coopts105814582coopts
coot67860382coo_t
copens106119962copens
copes97747102copes
cops86751372c_ops
cordons104415762cordons
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corn69945812corn_
cornu75921322cornu
cornus84816562cornus
corny106023272corny
corona83817402corona
coronas93916902coronas
corps95927042corps
cors66656442c_ors
cos510270392c_o_s
coses76949492coses
coss66143492c_oss
costs77231142costs
cotans81317922cotans
cotes76347842cotes
cots68054842c_ots
cottons9312192cottons
count74932052count
counts84618272counts
coupons112710552coupons
coups95522472coups
covens114919262covens
coves105539172coves
covins114618062covins
cowls106922212cowls
cows97046642c_ows
coxes145430862coxes
coys97537242c_oys
cozens176314922cozens
cozes166033242cozes
crocs95722432crocs
crone75231332crone
crones84729242crones
crony105918672crony
crooks124914412crooks
croon75522782croon_
crops96125232crops
cross75124502cross
crotons93714372crotons
crowns115615112crowns
crows105727312crows
curns74924272curns
cyans105714812cyans
cytons111710182cytons
dons56048702_dons
dooms85321342dooms
doors65022132doors
downs94918572downs
ebons74316092ebons
eons46638712_eons
exons125813342exons
fohns117310782fohns
foins85523382foins
fons76943892_fons
foods95924162foods
fools86824202fools
foots85528282foots
frons86124042frons
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goon57236172goon_
goony95519782goony
goops86620962goops
goos57644912goo_s
gowns95115102gowns
hons77350782_hons
hoods95124082hoods
hoofs115721042hoofs
hooks125027122hooks
hoops105621072hoops
hoots84830242hoots
horns86125332horns
icons76516492icons
ikons96311012ikons
ions46737852_ions
irons55324132irons
johns15398712johns
joins125818412joins
kaons95014852kaons
koans95818622koans
kooks85217262kooks
kroons103711242kroons
lions55923212lions
loans56026462loans
logons79818172logons
loins56728422loins
loofs85623782loofs
looks95124862looks
looms75124642looms
loon47344792loon_
loony86918962loony
loops75723962loops
loos49051122loo_s
loots55431422loots
moans74624362moans
monos75930862monos
mons68152252_mons
moods85224622moods
mools76027172mools
moon67140812moon_
moony104818272moony
moors74923142moors
moos66051302moo_s
moots75831662moots
morns75527442morns
morons84919542morons
muons75816172muons
neons55818682neons
nooks95420392nooks
noon47134622noon_
nouns56717312nouns
onos46229002_onos
ons36148512__ons
oohs75220692_oohs
oops65232672_oops
oots46446442_oots
owns76819582_owns
peons75327182peons
phons105221142phons
pions75826392pions
pons65850602_pons
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poon67341262poon_
poops94422412poops
poos65949112poo_s
porns75527342porns
racoons93912432racoons
roans54926442roans
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roots55933672roots
scions82612232scions
scoops105414362scoops
scoots85315932scoots
scorns85713012scorns
solons65120002solons
sons46049552_sons
sooks94425452sooks
soon46240502soon_
soots55536202soots
sorns55028412sorns
spoons84116012spoons
swoons94511142swoons
tons46553052_tons
tools55325242tools
toon47740632toon_
toots55331872toots
towns86018882towns
toyons95512122toyons
tycoons1235172tycoons
udons65411462udons
wons74942042_wons
woods95723032woods
woofs114918002woofs
wools84421462wools
woops104917522woops
woos76238802woo_s
zooks184716942zooks
zooms164415522zooms
zoon137326982zoon_
zoos135828802zoo_s

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 Filter178691538000.186960704.3
2DLD Change Limit538003185.9409057.2
3Display Results3183180.2801135.7
 (SQL Overall)1786913186.40627894.3
 
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.