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

214 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
posh9542732(None) 
bosh96328971bosh
cosh96127621cosh
gosh86123421gosh
josh145117611josh
mosh95227601mosh
nosh76223541nosh
pash95638131pash
pish96127911pish
poh86740531po_h
pooh96027381pooh
pose66441731pose
post67953361post
posy96028421posy
push95526621push
tosh74826811tosh
apish105116632apish
apos65433822apos_
ash67944602_ash
bash915240162bash
bos57966812bos_
bosk105825732bosk
boss65938342boss
both96533432both
bush96630712bush
cash96636282cash
cos510270392cos_
coss66143492coss
cost68057942cost
cosy97232702cosy
dash87031632dash
dish86328332dish
dos48062312dos_
dose56442432dose
doss56235042doss
dost57248352dost
doth86225712doth
epoch1248202epoch
epos66723732epos_
fash107232292fash
fish106926272fish
foh98135892fo_h
foss76431642foss
frosh115713402frosh
gash86833022gash
gos47155132gos_
goth86825082goth
gush85424002gush
hash106936502hash
hos68364192hos_
hose76547242hose
host77852832host
hush105224112hush
joss115925592joss
koph135816542koph
kos76944822kos_
koss85224812koss
lash76539652lash
loch95527132loch
lose45144582lose
loss45337962loss
lost47951492lost
loth76132132loth
lush75327692lush
mash96039392mash
mesh96823002mesh
mos57067122mos_
mosk105622442mosk
moss67641032moss
most66554202most
moth96731332moth
mush94929122mush
noh66640642no_h
nos38859322nos_
nose46739362nose
nosy76322892nosy
oh57447002_o_h
ohs66232312_ohs
ooh67637092_ooh
oohs75220692oohs
opah96218402opah
ops56641252ops_
os211359882_os_
ose38147342_ose
pah88853592p_ah
pas58775742pas_
pase65346862pase
pasha105417182pasha
pass65239952pass
past65959012past
path99134912path
pech116125452pech
peh86740962p_eh
pehs95625762pehs
pes57259782pes_
peso66925822peso
pest65555292pest
pis56362032pis_
piso66727562piso
piss65033332piss
pith95432692pith
plash104616562plash
plush105614712plush
poach124917862poach
pock126129292pock
poco86826152poco
pod66351482po_d
pods76540152pods
poem86225772poem
poesy105014062poesy
poet65552902poet
pogy105623552pogy
poi57244662po_i
pois66539042pois
poise75127892poise
poisha1135722poisha
poke105335362poke
poky135922152poky
pol56449382po_l
pole65951302pole
polish114916722polish
poll66332132poll
polo66236632polo
pols66044562pols
poly96235152poly
pom78249912po_m
pome85636692pome
pomo85828452pomo
pomp106225462pomp
poms87037742poms
pond75530492pond
pone65747532pone
pong76231142pong
pons65850602pons
pony96434052pony
poo57757112po_o
pooch124815302pooch
pood75934322pood
poof95541662poof
poohs103915712poohs
pool65835952pool
poon67341262poon
poop86532812poop
poor65630222poor
poos65949112poos
pop76252252po_p
pope85535612pope
popish133812112popish
pops86340952pops
popsy125713402popsy
porch125918622porch
pore66451262pore
pork106929682pork
porn65636022porn
port66059632port
posed85828412posed
poser75128772poser
poses74642762poses
posher115018162posher
poshly1437722poshly
posit75833332posit
posse74722272posse
posts75228782posts
pot58078432po_t
potash1138272potash
pots66452362pots
potsy105815612potsy
pouch124617082pouch
pouf95732642pouf
pour611527472pour
pout65752552pout
pow87147282po_w
pows95537662pows
pox126140692po_x
poxy166820892poxy
pros65742782pros_
prose75835122prose
proso77222412proso
pross76529402pross
prost75434102prost
prosy106319252prosy
psi56621622p_si
psst66118402psst
pst57932512p_st
pugh106619232pugh
pus55547842pus_
pushy134614352pushy
puss64830132puss
qoph185911942qoph
rash76039932rash
resh76523452resh
rose46148902rose
roshi8310752roshi
rosy76024872rosy
rush76628182rush
sash77235302sash
sh56828522__sh
skosh12407262skosh
slosh84514482slosh
soph97024202soph
sos37761602sos_
soth75932512soth
splosh1186542splosh
toph96326872toph
toss45637972toss
tost48351922tost
tush74523902tush
wash106033812wash
wish107228732wish
woosh113710732woosh
wos66953532wos_
wost76544362wost
yodh119916102yodh
yogh116616142yogh

Search took 3 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.1401276364.3
2DLD Change Limit298722141.98315064.0
3Display Results2142140.0932301.1
 (SQL Overall)1786912142.21680636.7
 
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.