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

334 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
petrols9291308(None) 
patrols93513511patrols
petrels9279371petrels
petrol82714061petrol_
petrous92714421petrous
enrols61213382_enrols
ketols104210762ket_ols
metols84115772met_ols
metros84217802metro_s
nerols6914882ne_rols
parols84722612p_arols
patrol83213022patrol_
patrons93818102patrons
pearls84715382pear_ls
pedros9312182pedro_s
perils84121852pe_rils
perrons93115482perrons
petals84719812pet_als
petiole9311302petiole
petioles10311632petioles
petrale9312622petrale
petrales10312952petrales
petrel83111532petrel_
petrolic1249692petrolic
petronels1146062petronels
peytrals1355492peytrals
peytrels1363372peytrels
pyrrols1235402pyrrols
retools73411022retools
retros63820192retro_s
sterols7313442sterols
tetryls1034642tetryls
anethols1145843anethols
apterous10410463apterous
astrals75515243astrals
bedroll1055553bedroll
bedrolls1144673bedrolls
befools1236433befools
benzols1836673benzols
beryls11107883be_ryls
bestrows1337043bestrows
betels84515063bet_els
bethels1238533bethels
betons84919553bet_ons
betrays12127823betrays
betroth1247543betroth
betroths1345633betroths
bettors93312473bettors
carols85124983_carols
centrals102712033centrals
ceorls848163ceor_ls
ceros74726073ce_ro_s
cerous85821203ce_rous
citrals91111663citrals
citrons92913223citrons
citrous93112983citrous
controls10311393controls
destroys1236693destroys
details84214043details
dewools1145593dewools
dextrous1646593dextrous
earls56127513_ear_ls
enols54718403_e_nols
enrol51014283_enrol_
enroll61110073_enroll
enrolls7108093_enrolls
eros45238453_e_ro_s
errors63311313_errors
estriols856253estriols
estrous7712533estrous
ethos85514193_etho_s
ethyls1235903_ethyls
euros54920243_euro_s
extols1337683_extols
ferals94216643fe_rals
ferrels10248623ferrels
ferrous1049793ferrous
fetials103711743fetials
fetors91014473fet_ors
fewtrils1443203fewtrils
genros74211333genro_s
herls85226433he_r_ls
heroes94923823he_roes
herons94820543he_rons
heros84930863he_ro_s
heteros10312683hetero_s
hotrods1148283hotrods
introns73515023introns
intros64215773intro_s
jetfoils1842453jetfoils
jetons134512613jet_ons
jetsoms16124723jetsoms
jettons1437273jettons
kestrels1235813kestrels
ketol95414003ket_ol_
leprous938843leprous
lethals1038113lethals
matrons93517633matrons
menthols1347033menthols
merls77423903me_r_ls
metals84520883met_als
meteors94610013meteors
methods1338883methods
methyls1535453methyls
metol75917813met_ol_
metrazols2043563metrazols
metres85121563metr_es
metrics11312363metrics
metro74718803metro__
natrons73215663natrons
nerol51017813ne_rol_
neroli61111153ne_roli
nerolis71012773ne_rolis
netops839213net_ops
neurons7410443neurons
neutrals846283neutrals
neutrons838293neutrons
nitrils72810703nitrils
nitros64214123nitro_s
nitrous73512483nitrous
octrois938333octrois
oestriols944323oestriols
oestrous869903oestrous
operons91411743ope_rons
outroll749303outroll
outrolls847823outrolls
outrows10311403outrows
parol74826273p_arol_
parole84425253p_arole
paroles95025883p_aroles
parous84024163p_arous
parrals94414573parrals
parrels94713493parrels
parrots9312743parrots
partons94620513partons
pathos115516693patho_s
patios85221783patio_s
patois84319363pat_ois
patriots1038053patriots
patron84018043patro_n
patronly1344883patronly
patroon92811973patroon
patroons102710603patroons
payroll1245613payroll
payrolls1344753payrolls
peafowls1642893peafowls
peals75235493pe__als
pearl75324463pear_l_
pearly116414843pear_ly
pears75138613pear__s
peartly1267453peartly
pectorals13128153pectorals
pedalos10329683pedalos
pedals94316033pe_dals
pedro8313153pedro__
peels75226423pe__els
peepuls1134923peepuls
peeress939503peeress
peeries93623023peeries
peers75130273peer__s
pekoes124410423pe_koes
pelorus939273pelorus
peltries10313023peltries
pencels113610053pencels
pencils113011763pencils
pengos94612413pengo_s
pennons939713pennons
pensils92811593pensils
pentanols1146113pentanols
pentyls1236523pentyls
peons75327183pe__ons
peplos101211543peplo_s
pepos96620083pe_po_s
perdus93711273pe_rdus
pereons92815003pereons
peres76246643pe_r_es
pergola1067623pergola
pergolas1158233pergolas
peril75425953pe_ril_
periods10312243periods
peris75537073pe_r_is
perks115325803pe_r_ks
perms95524513pe_r_ms
pernods1038483pernods
peroxy1838243pe_roxy
perps95521483pe_r_ps
perries93226603perries
perron83216623perro_n
perses85428063pe_rses
persons93717003persons
pertly115312543pe_rtly
pervs105117373pe_r_vs
pesos77221623pe_so_s
pesthole1347553pesthole
pestholes1448233pestholes
pestos84719083pesto_s
petal76526893pet_al_
petalous1058963petalous
petards104311153petards
petasos948603petasos
petasus946363petasus
petcock1744603petcock
petcocks1844583petcocks
peters86624593pet_ers
petiolar1046173petiolar
petioled1137993petioled
petites93820203petites
petnaps1145033petnaps
petrify1536573petrify
petroleum1353303petroleum
petroleums1452803petroleums
petrology1547333petrology
petronel1048143petronel
petrosal1047153petrosal
pets66248333pet___s
petsais938433petsais
petters93722363petters
pettily1238173pettily
pettle84116053pet_tle
pettles93916483pettles
petto76021043petto__
peyotls1233633peyotls
peytral1287503peytral_
peytrel1264253peytrel_
pharos11312063pharo_s
phenols1238103phenols
phytols15276553phytols
pierrots1044963pierrots
pistols93213983pistols
piteous9310683piteous
pitons85319043pit_ons
plectrons13258063plectrons
plurals936913plurals
podsols1056513podsols
podzols1934683podzols
poetries10315583poetries
pogroms1237643pogroms
poitrels1035243poitrels
pols66044563p___ols
polyols1238493polyols
pools74427703p__ools
porous84419483p_orous
portals94015563portals
potboils1284633potboils
potboys1475273potboys
potfuls1236293potfuls
pothole12312173pothole
potholes13312933potholes
pothos114214693potho_s
potions93417423potions
pottos84615873potto_s
precools1237703precools
pretells1047323pretells
pretold1049083pret_old
pretors9316803pret_ors
pretrials1158143pretrials
pretrims1238983pretrims
pretzels1934033pretzels
proas75028803p__roas
prods85523553p__rods
profs105120893p__rofs
progs86624153p__rogs
prole74527793p__role
proles84627203p__roles
proms95426403p__roms
props95726883p__rops
pros65742783p__ro_s
pross76529403p__ross
prowls115511083p__rowls
prows106327013p__rows
pterins9812993pterins
pteryla1243303pteryla
purls74723353p_ur_ls
putlogs1065083putlogs
putons83515153put_ons
pyrola1139003p_yrola
pyrolas1239863p_yrolas
pyros105718293p_yro_s
pyrrol1136273pyrrol_
pyrrole1246033pyrrole
pyrroles1345453pyrroles
pythons1537363pythons
recross989833recross
regrows11269153regrows
repros84216003repro_s
reroll6412683re_roll
rerolls739943re_rolls
retails74718973retails
retells73211523retells
retinols8419743retinols
retold73013753ret_old
retool63914483retool_
retorts76016513retorts
retral64419743retral_
retrials8510823retrials
retries74129073retries
retrims93612373retrims
retro55020953retro__
retrorse837623retrorse
safrols1036863safrols
serous65023553se_rous
serows96016393se_rows
setons64620173set_ons
setous64917373set_ous
sotols63714453sot_ols
sterol6613323sterol_
stools65117023_stools
stroll6311603_stroll
strolls739183_strolls
strops86220383_strops
strows96718273_strows
stroys95914603_stroys
terrors73112203terrors
tetrads82910173tetrads
tetras63017613tetr_as
tetris62816293tetr_is
tetrode839333tetrode
tetrodes939073tetrodes
tetryl935693tetryl_
tools55325243__tools
triols66117803__triols
trogs67022603__trogs
trois57226093__trois
troll54416533__troll
trolls64613943__trolls
trots56629943__trots
trows88826183__trows
troys86418613__troys
ventrals11299993ventrals
vetoes92914083vet_oes
vitriols1145053vitriols
wittols1035733wittols
zeroes154314343ze_roes
zeros144918103ze_ro_s

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273347.15618729.3
3Display Results3343340.1262650.8
 (SQL Overall)1786913347.43824024.1
 
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.