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

288 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
poons7543097(None) 
boons75031911boons
coons76737281coons
goons65326771goons
loons55731721loons
moons75331001moons
noons54125281noons
peons75327181peons
phons105221141phons
pions75826391pions
pons65850601p_ons
poods85124751poods
poofs105222791poofs
poohs103915711poohs
pools74427701pools
poon67341261poon_
poops94422411poops
poos65949111poo_s
porns75527341porns
spoons84116021spoons
toons55027531toons
zoons144919691zoons
aeons57624652aeons
agons66423782agons
aprons8316992aprons
axons125517932axons
azons146518252azons
boobs96221992boobs
books115729712books
booms95427122booms
boon67142172boon_
boors74325012boors
boos67955032boo_s
boots75837972boots
borons85520542borons
bosons85016652bosons
cions75222852cions
clons75228132clons
codons96119462codons
cogons96818112cogons
coins75834552coins
colons86028682colons
conns75024232conns
cons66057692_cons
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coon67248942coon_
coops96229642coops
coos67456492coo_s
coots75636842coots
corns76034762corns
croons85418422croons
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
hoots84830252hoots
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
moans74624372moans
monos75930862monos
mons68152262_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
opens76118552opens
owns76819582_owns
paeons83915522paeons
pains75138282pains
pans65855732p_ans
pawns108818132pawns
peans75437642peans
peens76428192peens
peins76128062peins
pens65649642p_ens
peon65635242peon_
peones83821042peones
peony105717562peony
phon95925382phon_
phone105621932phone
phones114121212phones
phono104917022phono
phonons123310252phonons
phonos114114792phonos
phony136715442phony
photons123814432photons
phots105418502phots
pians75126962pians
pinons86019942pinons
pins65558452p_ins
pion67235292pion_
pious74621272pious
pirns76020092pirns
pitons85319042pitons
plans75731272plans
pleons84213342pleons
plods85719292plods
plonk114613982plonk
plonks124210422plonks
plops95920332plops
plots75025672plots
plows105419902plows
ploys105816592ploys
poboys1397312poboys
pocks135022962pocks
pods76540152p_ods
poems95715552poems
poets76024442poets
poind84217912poind
poinds93511142poinds
point75338732point
points85618532points
pois66539042p_ois
poisons9310352poisons
pokes116133012pokes
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562p_ols
polys105718762polys
pomes94833932pomes
pomos95321582pomos
pompons1338552pompons
pomps115316192pomps
poms87037742p_oms
pond75530492p_ond
ponds85323402ponds
pone65747532p_one
pones74547042pones
pong76231142p_ong
pongs85526342pongs
pontons93315552pontons
pony96434052p_ony
poo57757112poo__
pooch124815302pooch
pood75934322poo_d
pooed85226242pooed
poof95541662poo_f
poofy136213272poofy
pooh96027382poo_h
pooing93820682pooing
pool65835952poo_l
poop86532812poo_p
poor65630222poo_r
poori74816232poori
pooris83916842pooris
poove104514302poove
pooves113914712pooves
popes95933812popes
pops86340952p_ops
pores75849032pores
porks115124142porks
porn65636022porn_
porno75120652porno
pornos85015252pornos
porny106020192porny
porous84419482porous
ports75934592ports
poses74642762poses
posts75228782posts
potions93417422potions
pots66452362p_ots
poufs105616062poufs
pound84417862pound
pounds93714382pounds
pours74623182pours
pouts75530322pouts
pows95537662p_ows
poxes145325722poxes
poyous112911622poyous
prions84317782prions
proas75028802proas
prods85523552prods
profs105120892profs
progs86624152progs
proms95426412proms
prone75332622prone
prong85218112prong
prongs94314482prongs
proofs114511682proofs
props95726882props
pros65742782pro_s
pross76529402pross
protons93118002protons
prows106327012prows
psoas75012982psoas
puns66641482p_uns
putons83515152putons
pyins105815862pyins
pylons113011242pylons
roans54926442roans
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roots55933672roots
solons65120022solons
sons46049552_sons
sooks94425452sooks
soon46240502soon_
soots55536212soots
sorns55028422sorns
spoofs114011812spoofs
spooks124312932spooks
spools85115912spools
spoon74719442spoon_
spoony114111792spoony
spoors84014032spoors
swoons94511142swoons
tons46553052_tons
tools55325242tools
toon47740632toon_
toots55331872toots
towns86018882towns
toyons95512132toyons
udons65411462udons
wons74942042_wons
woods95723032woods
woofs114918002woofs
wools84421462wools
woops104917522woops
woos76238802woo_s
zooks184716942zooks
zooms164415522zooms
zoon137326982zoon_
zoos135828802zoo_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 Limit538002881.45337026.8
3Display Results2882880.0763789.5
 (SQL Overall)1786912881.84297009.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.