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

146 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
pylori114716(None) 
pyloric1438061pyloric
peloria9310952peloria
peloric11310712peloric
poori74816232p_oori
pylon103614002pylo_n
pylons113011242pylons
pylorus1235332pylorus
byword1535053byword
bywork1834863bywork
caloric113413223caloric
calorie92716893calorie
calory11312843calory
chloric143410613chloric
chlorid133211843chlorid
chlorin123113003chlorin
colobi105011083colobi
coloni85619203coloni
color76123743color_
colors86622373colors
cyborg1443083cyborg
dolor67617963dolor_
dolors75115313dolors
ephori1139603ephori
flora85317103_flora
florid10311453_florid
florin9312653_florin
galore73514853galore
gloria71910543_gloria
glory96413293_glory
gyri85415153gy__ri
lari45839153__lari
liri45128253__liri
loci66126283__loci
lord55032083__lord
lore45850353__lore
loris55329153__loris
lorn46435253__lorn
lory75931713__lory
loti46431843__loti
maloti8313213maloti
milord999573milord
mylar105311533mylar_
mylars114310443mylars
nori47133143__nori
nylon82910513nylo_n
nylons9267973nylons
padri85815173p_adri
pakora1247283pakora
paler75436933paler_
pallor8313673pallor_
pallors9314363pallors
palpi95414553pal_pi
paltry114910403paltry
papyri1334903papyri
parlor8312673parlor_
parlors9312913parlors
payload1336403payload
payor105413843payor_
payors114312643payors
pelon74423213pelo_n
pelorian1048883pelorian
pelorias10410593pelorias
pelorus939273pelorus
pelota8612833pelota
peltry11288653peltry
peri65636973p__eri
phloem1335713phloem
phlox1737333phlo_x
phylar14437373phylar_
phylon14318033phylo_n
pilar75221503pilar_
pilei74021783pil_ei
pilgrim1244643pilgrim
pili66130353pil__i
pillory12247453pillory
pilose84514243pilose
pilot77435063pilo_t
pilots84018873pilots
pilous84717753pilous
pirogi9299013pirogi
plod76723273p_lo_d
plods85719293p_lods
plonk114613983p_lonk
plop86625743p_lo_p
plops95920333p_lops
plot66141233p_lo_t
plots75025673p_lots
plotz164617003p_lotz
plow95923233p_lo_w
plows105419903p_lows
ploy96123603p_lo_y
ploys105816593p_loys
plyer106214333plyer_
plyers114912983plyers
poi57244663p__o_i
polar75623453polar_
polars84419353polars
poler74431793poler_
polers84225643polers
polo66236633polo__
polos76129913polo_s
polypi13458593polypi
poor65630223p_oor_
pooris83916843p_ooris
pore66451263p__ore
pork106929683p__ork
porn65636023p__orn
port66059633p__ort
prior74316173prior_
priors83914483priors
priory114110263priory
psoai7469923p_soai
puler74826623puler_
pulers83820283pulers
puli65527623pul__i
puri65931443p__uri
pyoid11513763py_oid
pyosis114012123py_osis
pyre94925553py__re
pyric123815073py__ric
pyro96019393py__ro
pyrola1139003pyrola
pyrone112714473pyrone
pyrope132810533pyrope
pyros105718293pyro_s
pyrosis12411653pyrosis
pyrrol1136273pyrrol
pyuria1136953py_uria
satori6415843satori
sori46039843__sori
splore81611303splore
syli74318983syl__i
teloi54217383telo_i
tori47542153__tori
tylosin1046903tylosin
valor83614893valor_
valors93413773valors
xyloid1738193xyloid
xylol1546133xylo_l
xylols1634173xylols
xylose1636763xylose
yogi86120423_y_ogi
yoni77524393_y_oni
yore76335943_y_ore
zori137722923__zori

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.1401276364.3
2DLD Change Limit1127161465.54620323.8
3Display Results1461460.0463173.9
 (SQL Overall)1786911465.73231174.3
 
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.