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 “polyps” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

455 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
polyps1347976(None) 
polyp125611531polyp_
polypi13458591polypi
polypus14346931polypus
polys105718761poly_s
palps94719562pal_ps
plops95920332p_lops
ploys105816592ploy_s
polars84419352polars
poleis86018352poleis
polers84225642polers
poles75351002pol_es
poleyns1236112poleyns
polies84034582polies
polios84019722polios
polis74731162pol_is
polkas1239102polkas
polls74627722pol_ls
polos76129912pol_os
pols66044562pol__s
poly96235152poly__
polyol1138712polyol
polyols1238492polyols
polyped1537172polyped
polypeds1645772polypeds
polypod1546982polypod
polypods1647112polypods
polypous1547982polypous
pomps115316192po_mps
poops94422412po_ops
pops86340952po__ps
pulps95116482pul_ps
tolyls9436962tolyls
allyls9437273allyls
alps65529243_al_ps
apollos946793apollos
apologs1038593apologs
blips95615783_blips
bloops106611343bloops
blype12429673_blype
blypes13357543_blypes
bolas74733763bol_as
bolds85825283bol_ds
boles75448603bol_es
bolls75531313bol_ls
bolos75531373bol_os
bolts76232113bol_ts
bolus79125543bol_us
bops86037983bo__ps
boylas113011723boylas
boyos105418283bo_yos
boys96737333bo_y_s
calypso1443123calypso
claps95626183_claps
clips96018303_clips
clomps125212233clomps
clops95924853_clops
cloys104916943cloy_s
colas75436773col_as
colbys13407153colbys
colds85726973col_ds
coles76055063col_es
coleus86818273coleus
colics104219903colics
colies84837053colies
colins85229043colins
collops112611753collops
cologs96517353cologs
colons86028683colons
colors86622373colors
cols66553083col__s
colts76633293col_ts
coly96940533coly__
colzas174010513colzas
comps115526053co_mps
coops96229643co_ops
cops86751373co__ps
corps95927043co_rps
cotype1346823cotype
cotypes1437943cotypes
coups95522473co_ups
coypu12349873co_ypu
coypus13389303co_ypus
coys97537243co_y_s
doles67843753dol_es
dollops10287963dollops
dolls66126923dol_ls
dolmas95213043dolmas
dolors75115313dolors
dols56943053dol__s
dolts65626313dol_ts
dorps85419223do_rps
eponyms1444853eponyms
flaps105621383_flaps
flips105117743_flips
flops105920143_flops
folds95221693fol_ds
foldups1332733foldups
foleys123810463foleys
folios93915463folios
folks126017123fol_ks
folles93820473folles
follis93113903follis
fops96532683fo__ps
foys105628293fo_y_s
galops94712623galops
glops85619553_glops
glyph1456473_glyph
glyphs1534303_glyphs
golds75421313gol_ds
golems939323golems
golfs95616103gol_fs
goops86620963go_ops
gorps85316993go_rps
goys86328413go_y_s
gulps84715073gul_ps
gyps105115023__gyps
helps105219343hel_ps
holds94623243hol_ds
holdups1333593holdups
holes84748653hol_es
holies94630033holies
holks124720563hol_ks
hollas94616903hollas
hollos95320633hollos
holms105117803hol_ms
holp95727553hol_p_
hols76946293hol__s
holts85627913hol_ts
holy106333433holy__
hoops105621073ho_ops
hops97942633ho__ps
hoyas115016163ho_yas
hoyles12315013hoyles
hoys107733933ho_y_s
hyps125418413__hyps
jalaps15299183jalaps
jalops15329593jalops
joeys15518043joey_s
joles125230833jol_es
jolts125018883jol_ts
joys146624663jo_y_s
juleps1535623juleps
keleps12478813keleps
kelps115116423kel_ps
kolas94822233kol_as
kolos94921213kol_os
kops107031293ko__ps
laps66848873__laps
lips67141443__lips
lollops9227443lollops
lolls512121733lol_ls
loops75723963lo_ops
lops66043353__lops
loups75319623lo_ups
lyes75530833__lyes
molars85517323molars
molas75132093mol_as
molds85324833mol_ds
moles74747923mol_es
molies84429513molies
molls75129783mol_ls
mols65948573mol__s
molts76032093mol_ts
moly96031913moly__
mops85940133mo__ps
nolos54423353nol_os
nonyls957853nonyls
odyls9428653_odyls
olds55926573_ol_ds
oleos55419683_oleos
oles46453473_ol_es
olios54520853_olios
ollas54218283_ollas
oops65232673_o_ops
ops56641253_o__ps
orlops847303orlops
oxlips1544433oxlips
oyes74940133_o_yes
palais8420423palais
palapa10310673palapa
palapas11311493palapas
pales75753803pal_es
palets85122313palets
palls74332563pal_ls
palms94921753pal_ms
palp85828573pal_p_
palpi95414553pal_pi
palpus104210283palpus
pals66951353pal__s
paly95835533paly__
paps86443453p__aps
pays95940223p_ay_s
peeps95822363p_eeps
peles75738083pel_es
pelfs105016293pel_fs
pelts76128813pel_ts
pelves114514663pelves
pelvis113610323pelvis
peps85134513p__eps
perps95521483p_erps
pilafs113511023pilafs
pilaus84114133pilaus
pilaws11399433pilaws
piles74742613pil_es
pileups11365433pileups
pileus84514943pileus
pilis75825203pil_is
pills74130973pil_ls
pilots84018873pilots
pilous84717753pilous
pilus75921063pil_us
pily96132733pily__
pimps114616983p_imps
pinups1037413pinups
piolets93513193piolets
pips85837133p__ips
plans75731273p_lans
plats75531373p_lats
playas114612283playas
plays106320773p_lays
pleas75627033p_leas
plebs95814583p_lebs
plews105415353p_lews
plies74526513p_lies
plods85719293p_lods
plonks124210423plonks
plop86625743p_lop_
plots75025673p_lots
plows105419903p_lows
ploy96123603ploy__
ployed124310563ployed
plugs85213493p_lugs
plumps124612613plumps
plums94619953p_lums
plus66324833p_l_us
ply86323553p_ly__
plyer106214333p_lyer
plyers114912983p_lyers
poboys1397313poboys
pocks135022963po_cks
pods76540153po__ds
poems95715553po_ems
poets76024443po_ets
pogeys124110353pogeys
pogies94123543pogies
pogy105623553pogy__
poilus82210573poilus
poinds93511143poinds
points85618533points
pois66539043po__is
poises84226543poises
pokers124617923pokers
pokes116133013po_kes
pokeys15529513pokeys
pokies125921333pokies
poky135922153poky__
pol56449383pol___
polar75623453pol_ar
polder94019253polder
polders103617373polders
pole65951303pol__e
poleax1547993poleax
poled84934843pol_ed
poler74431793pol_er
poleyn1157323poleyn
police102918563police
polices113118053polices
policy133211513policy
poling93526503poling
polio75722553pol_io
polish114916723polish
polite83625073polite
polity113015863polity
polka11310413pol_ka
poll66332133pol__l
polled94022003polled
pollee83623273pollee
pollees93215333pollees
pollen83416453pollen
pollens93713303pollens
poller83921853poller
pollers93420023pollers
pollex153711163pollex
pollist9816603pollist
polo66236633pol__o
poloist91016323poloist
polycot14510123polycot
polycots1547763polycots
polyene1259363polyene
polyenes13510063polyenes
polygon1346933polygon
polygons1447723polygons
polymer1438063polymer
polymers1538333polymers
polynya1544063polynya
polynyas1644453polynyas
polynyi1544093polynyi
polyoma1447023polyoma
polyomas1546993polyomas
polypary1855113polypary
polyphase1945093polyphase
polypide1647013polypide
polypides1747073polypides
polypnea1544253polypnea
polypneas1644003polypneas
polypody1944963polypody
polypoid1648393polypoid
polypore1547453polypore
polypores1648003polypores
polypuses1645603polypuses
polytype1844753polytype
polytypes1945173polytypes
pomes94833933po_mes
pomos95321583po_mos
pomp106225463po_mp_
poms87037743po__ms
ponces104720843ponces
ponds85323403po_nds
pones74547043po_nes
pongs85526343po_ngs
ponies84833463ponies
pons65850603po__ns
pontes83627853pontes
pony96434053pony__
poods85124753po_ods
poofs105222793po_ofs
poohs103915713po_ohs
poolers94217423poolers
pools74427703po_ols
poons75430973po_ons
poop86532813po_op_
pooris83916843pooris
poos65949113po__os
pooves113914713pooves
pop76252253po__p_
pope85535613po__pe
popes95933813po_pes
poplars113910333poplars
poplins11313153poplins
poppa8409893po_ppa
poppas93710713poppas
poppy114813193po_ppy
popsy125713403po__psy
pores75849033po_res
porks115124143po_rks
pornos85015253pornos
porns75527343po_rns
porous84419483porous
ports75934593po_rts
posers84223973posers
poses74642763po_ses
posies84431433posies
posits85718713posits
posses85128803posses
postops11311713postops
posts75228783po_sts
posy96028423posy__
pothos114214693pothos
pots66452363po__ts
pottos84615873pottos
pouffs14418123pouffs
poufs105616063po_ufs
poults84613483poults
pounds93714383pounds
pours74623183po_urs
pouts75530323po_uts
powers113822323powers
pows95537663po__ws
poxes145325723po_xes
poxy166820893poxy__
poyou102611523po_you
poyous112911623poyous
prays105022433pray_s
preops104911943preops
preps96220693p_reps
preys105717783prey_s
primps124711823primps
prolans9314273prolans
prolapse12134913prolapse
prolegs10379993prolegs
proles84627203prol_es
prologs103512133prologs
props95726883p_rops
propyls14308193propyls
protyls12298463protyls
psyops1334343psyops
pulers83820283pulers
pules74538813pul_es
pulis74225603pul_is
pulls74425053pul_ls
pullups1134233pullups
pulp84825353pul_p_
pulpy124612363pul_py
puls65437563pul__s
pulses83818663pulses
pumps115520603p_umps
pups86032233p__ups
pyas96225703p__yas
pyes95528993p__yes
pylons113011243pylons
roles56747983rol_es
rolfs84817123rol_fs
rolls55326233rol_ls
romps94617543ro_mps
roups75118903ro_ups
saleps85014903saleps
salps74423243sal_ps
shleps114710333shleps
slaps76025713_slaps
slips76023723_slips
sloops85513623sloops
slops75026013_slops
sloyds10346293sloyds
slype105112363_slype
slypes114410483_slypes
soaps75120713so_aps
solans64122493solans
soles55547923sol_es
soleus64615613soleus
solids74116403solids
solons65120023solons
solos54830793sol_os
sols45448163sol__s
solums85211333solums
solus54726983sol_us
solves95018223solves
sops65244563so__ps
soups75322943so_ups
soyas84520913so_yas
soys75233933so_y_s
tolans64319273tolans
tolars64817943tolars
tolas54532773tol_as
toles55147133tol_es
tolls54728433tol_ls
tolus55024483tol_us
toluyls1032833toluyls
tolyl84710093toly_l
tops66248123to__ps
toyos87519143to_yos
toys78036343to_y_s
tulips8137253tulips
voles86234043vol_es
voltes94915583voltes
volts85421293vol_ts
volvas12447993volvas
wolds95420183wol_ds
wolfs116214163wol_fs
wolves124510853wolves
woops104917523wo_ops
wops96634153wo__ps
xylyls1931833xylyls
yelps105712993yel_ps
yolks125412773yol_ks

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127164555.15621861.1
3Display Results4554550.1403250.0
 (SQL Overall)1786914555.68631426.5
 
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.