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

217 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
poem8622577(None) 
poems95715551poems
poet65552901poet
pom78249911po_m
pome85636691pome
proem94818271proem
ahem97225362ahem
boom87435672boom
coed77140542coed
come87547702come
corm85735372corm
deem75432892deem
doe47361952doe_
doer57734702doer
does56554472does
dom69752442do_m
dome77240732dome
doom76430072doom
dorm76834622dorm
doum76226672doum
em49445152__em
fem86040732_fem
foam97127172foam
foe66350812foe_
foes76543442foes
form95836872form
gem66840222_gem
goer56827102goer
goes55644092goes
golem8416112golem
gorm75529392gorm
haem95730982haem
hem86148732_hem
hoe67562722hoe_
hoed87837982hoed
hoer76533982hoer
hoes75755732hoes
holm95628102holm
home98042442home
idem76121062idem
item65620382item
joe106642352joe_
joes116635892joes
joey145719332joey
koel84519942koel
loam65630482loam
loom67035052loom
mem77943472_mem
modem103717142modem
mom78853162mo_m
mome85239352mome
neem67328082neem
noel45226552noel
noes45845392noes
nom510450642no_m
nome66038422nome
norm66429812norm
oe28473062_oe_
oes35866192_oes
ohm86523012_ohm
om48553002_o_m
ope56845242ope_
oped76230152oped
open66427002open
opes65942612opes
palm85331362palm
pam77858392p_am
pe47649032p_e_
pea56657242p_ea
pec76744412p_ec
ped66751522p_ed
pee56066512p_ee
peed76239182peed
peek106031432peek
peel65535612peel
peen65938082peen
peep85833692peep
peer66238352peer
pees65257372pees
peg65843062p_eg
peh86740962p_eh
pen56558842p_en
peon65635242peon
pep76447082p_ep
per56353092p_er
perm85834632perm
pes57259782p_es
pet56477302p_et
pew86442302p_ew
phew128417112phew
phloem1335702phloem
pie55457402pie_
pied75035362pied
pier66035292pier
pies66949602pies
plea66830602plea
pleb86123812pleb
pled75231432pled
plew97222812plew
plex137321372plex
plum85122102plum
pock126129292pock
poco86826152poco
pod66351482po_d
pods76540152pods
poesy105014062poesy
poets76024442poets
pogey116017892pogey
pogy105623552pogy
poh86740532po_h
poi57244662po_i
pois66539042pois
poke105335362poke
poked125425392poked
poker115122882poker
pokes116133012pokes
pokey145318972pokey
poky135922152poky
pol56449382po_l
pole65951302pole
poled84934842poled
poler74431792poler
poles75351002poles
poll66332132poll
polo66236632polo
pols66044562pols
poly96235152poly
pomes94833932pomes
pommy14449862pommy
pomo85828452pomo
pomp106225462pomp
poms87037742poms
pond75530492pond
pone65747532pone
pones74547042pones
pong76231142pong
pons65850602pons
pony96434052pony
poo57757112po_o
pood75934322pood
pooed85226242pooed
poof95541662poof
pooh96027382pooh
pool65835952pool
poon67341262poon
poop86532812poop
poor65630222poor
poos65949112poos
pop76252252po_p
pope85535612pope
popes95933812popes
pops86340952pops
pore66451262pore
pored85234512pored
pores75849032pores
pork106929682pork
porn65636022porn
port66059632port
pose66441732pose
posed85828412posed
poser75128772poser
poses74642762poses
posh95427322posh
post67953362post
posy96028422posy
pot58078432po_t
pots66452362pots
pouf95732642pouf
pour611527472pour
pout65752552pout
pow87147282po_w
power105325952power
pows95537662pows
pox126140692po_x
poxed154817862poxed
poxes145325722poxes
poxy166820892poxy
pram85733492pram
pree67044732pree
prep86427672prep
prex135722972prex
prey96228482prey
prez156126312prez
prim85132202prim
proems104711162proems
prom87631692prom
pye86432502pye_
pyes95528992pyes
rem56150042_rem
roam67132412roam
roe36861072roe_
roes45954132roes
rom59855632ro_m
room66235082room
seem65438562seem
som59153802so_m
some66040382some
stem610628242stem
teem66132602teem
them97427042them
toe310166852toe_
toea46732332toea
toed56137042toed
toes46956442toes
tom514358052to_m
tome67543192tome
toom66532932toom
totem74819362totem
voe67739052voe_
voes75432822voes
woe66651242woe_
woes76440662woes
worm96129482worm
ylem9217892ylem
yom88043442yo_m
zoea137118422zoea
zoom156722102zoom

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 Filter178691298720.0762351197.4
2DLD Change Limit298722170.90632971.3
3Display Results2172170.0504340.0
 (SQL Overall)1786912171.032173150.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.