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

165 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
pyrrol113627(None) 
pyrrole1246031pyrrole
pyrrols1235401pyrrols
parol74826272p_arol
parral85517532parral
parrel84515982parrel
parrot8320662parrot
patrol83213022patrol
perron83216622perron
petrol82714062petrol
pyro96019392py_ro_
pyrola1139002py_rola
pyros105718292py_ros
pyrroles1345452pyrroles
pyrrolic1544562pyrrolic
argol65317263_argol
arrow83414883_arrow
barrel84517873barrel
barrow114512763barrow
borrow114310723borrow
burro75018493burro_
burros85114993burros
burrow114610803burrow
byrl95716013by_r_l
carol75128613_carol
carrel84718633carrel
carrom10513403carrom
carrot8423123carrot
corral83616253corral
cymol1287623cy_mol
drool65416103_drool
enrol51014283_enrol
error53712233_error
farrow12309973farrow
ferrel92810203ferrel
formol112910333formol
furrow12427743furrow
garron73113493garron
gyral94412783gy_ral
gyro85217883gy_ro_
gyron95314623gy_ron
gyros95616483gy_ros
harrow122610773harrow
horror988723horror
hydro12259423hydro_
hydros13279363hydros
karroo10410013karroo
marron83717543marron
marrow112812603marrow
mirror848003mirror
morro73216953morro_
morros83714673morros
morrow113510093morrow
myrrh1337093myrr_h
myrrhs1443603myrrhs
narrow9269143narrow
nerol51017813_nerol
parasol939553parasol
parboil1138323parboil
parcel103915473parcel
pardon94618733pardon
pareo74632603pareo_
pareos87023773pareos
pargo86723723pargo_
pargos95719043pargos
parlor8312673parlor
parole84425253p_arole
parols84722613p_arols
parr65731153parr__
parrals94414573parrals
parred95024073parred
parrels94713493parrels
parrots9312743parrots
parroty1247863parroty
parrs75928673parr_s
parry105323753parr_y
parson83817903parson
parton84720993parton
parvo107719183parvo_
parvos116614753parvos
patrols93513513patrols
patron84018043patron
payroll1245613payroll
pearl75324463pear_l
pedro8313153pedro_
pedros9312183pedros
pereon83517453pereon
pergola1067623pergola
peril75425953p_eril
period9314983period
pernod9310453pernod
peroral9314793peroral
perrons93115483perrons
perry105222713perr_y
person83517873person
petrel83111533petrel
petrols92913083petrols
peytral1287503peytral
peytrel1264253peytrel
pharos11312063pharos
phenol1149253phenol
phytol14366563phytol
pierrot948833pierrot
pirog83913673p_irog
pistol83313333pistol
plural839823plural
podsol946853podsol
podzol1835083podzol
pogrom1138593pogrom
pol56449383p___ol
polyol1138713polyol
pool65835953p__ool
porno75120653porno_
pornos85015253pornos
portal84218463portal
prao66229023p_rao_
praos74923563p_raos
preop94715873p_reop
prill74117943p_rill
prion75119993p_rion
prior74316173p_rior
pro55837263p__ro_
proa66229963p__roa
prod76129503p__rod
prof96134663p__rof
prog75729003p__rog
prole74527793p__role
prom87631693p__rom
proof105221533p_roof
prop85932813p__rop
pros65742783p__ros
prow97030383p__row
prowl105615123p_rowl
purl65631423p_ur_l
purr64925813purr__
purred94218073purred
purrs75320433purr_s
pylon103614003py_lon
pylori1147163pylori
pyran10514473py_ran
pyrans11411063pyrans
pyre94925553py_r_e
pyrene113210733pyrene
pyres105523883py_res
pyrex175211213py_rex
pyric123815073py_ric
pyrite11913313pyrite
pyrolas1239863py_rolas
pyrone112714473pyrone
pyrope132810533pyrope
pyrrhic1744073pyrrhic
python1447143python
pyuria1136953pyuria
safrol937283safrol
sorrel6413543sorrel
sorrow9339443sorrow
sparrow1234263sparrow
sterol6613323sterol
symbol1336083symbol
terror63811723terror
triol55521363_triol
tyro76622363ty_ro_
tyros85118593ty_ros
xylol1546133xy_lol
yarrow12287933yarrow

Search took 7 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 Limit1127161656.01618736.0
3Display Results1651650.0463587.0
 (SQL Overall)1786911656.20228811.8
 
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.