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

141 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
polypi1345859(None) 
polyp125611531polyp_
polyps13479761polyps
palpi95414552pal_pi
poly96235152poly__
polynyi1544092polynyi
polyol1138712polyol
polyped1537172polyped
polypide1647012polypide
polypod1546982polypod
polypoid1648392polypoid
polypus14346932polypus
polys105718762poly_s
blype12429673_blype
boleti8413403boleti
clypei1334163_clypei
colobi105011083colobi
coloni85619203coloni
coly96940533coly__
cotype1346823cotype
coypu12349873co_ypu
dolci84912603dol_ci
glyph1456473_glyph
holp95727553hol_p_
holy106333433holy__
moly96031913moly__
okapi1136613_okapi
palapa10310673palapa
palp85828573pal_p_
palps94719563pal_ps
paly95835533paly__
pappi84810893p_appi
papyri1334903papyri
pilei74021783pil_ei
pili66130353pil__i
pily96132733pily__
platypi1442753platypi
plop86625743p_lop_
plops95920333p_lops
ploy96123603ploy__
ployed124310563ployed
ploys105816593ploy_s
ply86323553p_ly__
plyer106214333p_lyer
pogy105623553pogy__
poi57244663po___i
poky135922153poky__
pol56449383pol___
polar75623453pol_ar
polars84419353polars
polder94019253polder
pole65951303pol__e
poleax1547993poleax
poled84934843pol_ed
poleis86018353poleis
polemic13311253polemic
poler74431793pol_er
polers84225643polers
poles75351003pol_es
poleyn1157323poleyn
poleyns1236113poleyns
police102918563police
policy133211513policy
polies84034583polies
poling93526503poling
polio75722553pol_io
polios84019723polios
polis74731163pol_is
polish114916723polish
polite83625073polite
politic112918713politic
polity113015863polity
polka11310413pol_ka
polkas1239103polkas
poll66332133pol__l
polled94022003polled
pollee83623273pollee
pollen83416453pollen
poller83921853poller
pollex153711163pollex
polls74627723pol_ls
polo66236633pol__o
polos76129913pol_os
pols66044563pol__s
polybrid1646213polybrid
polycot14510123polycot
polyene1259363polyene
polyenic1547673polyenic
polygon1346933polygon
polymer1438063polymer
polynya1544063polynya
polyols1238493polyols
polyoma1447023polyoma
polyparia1645793polyparia
polypary1855113polypary
polypeds1645773polypeds
polypides1747073polypides
polyploid1746143polyploid
polypnea1544253polypnea
polypneic1854063polypneic
polypods1647113polypods
polypody1944963polypody
polypore1547453polypore
polypous1547983polypous
polytype1844753polytype
polytypic2143943polytypic
polyuria1355823polyuria
polyuric1555623polyuric
polyzoic2445393polyzoic
pomp106225463po_mp_
pomps115316193po_mps
pony96434053pony__
poop86532813po_op_
poops94422413po_ops
poori74816233po_ori
pop76252253po__p_
pope85535613po__pe
poppa8409893po_ppa
poppy114813193po_ppy
pops86340953po__ps
porkpie1544673porkpie
posy96028423posy__
potpie103412433po_tpie
poxy166820893poxy__
poyou102611523po_you
priapi1037923priapi
puli65527623pul__i
pulp84825353pul_p_
pulpit10310933pul_pit
pulps95116483pul_ps
pulpy124612363pul_py
pylori1147163pylori
slype105112363_slype
soldi65717203sol_di
solei55624343sol_ei
soli46637013sol__i
solidi73813153solidi
tolyl84710093toly_l
tolyls9436963tolyls
topi67830393to__pi
volti84915963vol_ti

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 Limit1127161414.80023482.5
3Display Results1411410.0463065.2
 (SQL Overall)1786911415.23634127.4
 
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.