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

265 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
poets7602444(None) 
pets66248331p_ets
poems95715551poems
poet65552901poet_
ports75934591ports
posts75228781posts
pots66452361po_ts
pouts75530321pouts
abets75621672abets
beets76131442beets
bets67051442_bets
blets75324942blets
boats75635152boats
bolts76232112bolts
boots75837972boots
borts76735452borts
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
coats75634992coats
coeds85920162coeds
colts76633292colts
comets105823582comets
coots75636842coots
cosets85824402cosets
costs77231142costs
cotes76347842cotes
cots68054842co_ts
covets114819642covets
deets65330242deets
diets66026642diets
doats65224882doats
doers65225712doers
does56554472doe_s
doest65829522doest
doeth9411982doeth
doits66223672doits
dolts65626312dolts
dotes65836692dotes
dots55647662do_ts
duets65323882duets
fets75345942_fets
foes76543442foe_s
foetus958522foetus
fonts86124752fonts
foots85528282foots
forts86034452forts
frets85523402frets
gets55442482_gets
goats65527302goats
godets8410932godets
goers65520252goers
goes55644092goe_s
gouts64826172gouts
haets86525122haets
hets75547202_hets
hoers85724922hoers
hoes75755732hoe_s
holts85627912holts
hoots84830242hoots
hosts85526702hosts
hots78349322ho_ts
jets115834102_jets
joes116635892joe_s
joeys15518042joeys
jolts125018882jolts
jots116336142jo_ts
keets95123482keets
khets124913432khets
koels94613902koels
leets54927122leets
lets47147942_lets
loess55714702loess
lofts85518362lofts
loots55431422loots
lots47652092lo_ts
louts56330272louts
meets74224612meets
moats75827642moats
molts76032092molts
moots75831662moots
morts75533562morts
mosts76028542mosts
motes75944002motes
motets84216192motets
mots66853162mo_ts
motts76527002motts
nets45941532_nets
noels56418702noels
noes45845392noe_s
nonets64118702nonets
notes55034582notes
nowts86915852nowts
oats46554212_oats
oes35866192_oe_s
oots46446442_oots
opens76118552opens
opes65942612ope_s
opts68124742_opts
orts46538332_orts
outs45746962_outs
pacts95125802pacts
palets85122312palets
pants76536922pants
parts77743372parts
pasts75936502pasts
pates76047892pates
pats66460852p_ats
peas65755062p_eas
peats76140192peats
pecs84634102p_ecs
peds75835242p_eds
peeks115021112peeks
peels75226422peels
peens76428192peens
peeps95822362peeps
peers75130272peers
pees65257372p_ees
pegs75531762p_egs
pehs95625762p_ehs
pelts76128812pelts
pens65649642p_ens
peons75327182peons
peps85134512p_eps
pes57259782p_e_s
pest65555292p_est
pests75933272pests
pet56477302p_et_
pews95731532p_ews
phots105418492phots
phuts104613502phuts
piers75926332piers
pies66949602pie_s
pieta75421752pieta
pietas84516502pietas
piety105817302piety
pints75936222pints
piolets93513192piolets
pipets105714772pipets
pits66348742p_its
plats75531372plats
pleas75627032pleas
pleats85218592pleats
plebs95814582plebs
plews105415352plews
plots75025672plots
pockets154612252pockets
pocks135022962pocks
pods76540152po_ds
poem86225772poe_m
poesy105014062poesy
poetess938932poetess
poetic10416842poetic
poetics11312072poetics
poetise9314042poetise
poetry1139382poetry
pogeys124110352pogeys
points85618532points
pois66539042po_is
pokers124617922pokers
pokes116133012pokes
pokeys15529512pokeys
poleis86018352poleis
polers84225642polers
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562po_ls
polys105718762polys
pomes94833932pomes
pomos95321582pomos
pomps115316192pomps
poms87037742po_ms
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602po_ns
pontes83627852pontes
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
poos65949112po_os
popes95933812popes
poppets10338852poppets
pops86340952po_ps
pores75849032pores
porks115124142porks
porns75527342porns
port66059632port_
posers84223972posers
poses74642762poses
posits85718712posits
possets94212772possets
post67953362post_
pot58078432po_t_
potsy105815612po_tsy
potto75320942potto
pottos84615872pottos
potty105621002potty
poufs105616062poufs
poults84613482poults
pours74623182pours
pout65752552pout_
pouty107018812pouty
powers113822322powers
pows95537662po_ws
poxes145325722poxes
prats76333392prats
prees75937172prees
preps96220692preps
press75425952press
prest75736352prest
prests84021262prests
preys105717782preys
proems104711162proems
projets1639162projets
punts75828002punts
puts65641752p_uts
putts75719272putts
pyes95528992pye_s
rets45352562_rets
roes45954132roe_s
roots55933672roots
rosets65819952rosets
rotes56143902rotes
rots46454092ro_ts
routs57133412routs
sets45549502_sets
softs85019232softs
soots55536202soots
sorts54536662sorts
sots45552442so_ts
sports84619182sports
spots74424102spo_ts
spouts85115112spouts
stets55423912stets
suets55126102suets
tets45847452_tets
toeas55726422toeas
toes46956442toe_s
tofts84919242tofts
toits55327472toits
toots55331872toots
torts56138122torts
totes55139682totes
tots46654122to_ts
touts54830392touts
trets55928022trets
upsets8409682upsets
vets76835092_vets
voes75432822voe_s
volts85421292volts
votes84627082votes
weets85427722weets
wets75940292_wets
whets115019612whets
woes76440662woe_s
wonts87621542wonts
worts88631182worts
wots76342892wo_ts
zoeas145815612zoeas

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.0931921408.6
2DLD Change Limit538002651.58034050.6
3Display Results2652650.0763486.8
 (SQL Overall)1786912651.749102167.5
 
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.