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

432 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
patrol8321302(None) 
parol74826271pa_rol
patrols93513511patrols
patron84018041patron
petrol82714061petrol
carol75128612ca_rol
matron83918312matron
natron64116022natron
parole84425252pa_role
parols84722612pa_rols
parral85517532parral
parrel84515982parrel
parrot8320662parrot
parton84720992parton
pathos115516692pathos
patio74426352patio_
patios85221782patios
patriot9314532patriot
patronal1048652patronal
patronly1344882patronly
patrons93818102patrons
patroon92811972patroon
payroll1245612payroll
petrel83111532petrel
petrols92913082petrols
pyrrol1136272pyrrol
safrol937282safrol
aero45435343_aero_
aldol61212333_aldol
amatol838683amat_ol
antral65719413antral
apron7318833_apron
apteral9311523apteral
argol65317263_argol
aril45843023_a_ril
arrow83414883_arrow
artal55525473_artal
artel56122743_artel
aryl75922343_a_ryl
astral66919283astral
atoll57913923_atoll
atom67824523_at_om
atop66124753_at_op
atria56022333_atria
atrial65418943_atrial
atrip75315743_atrip
aural54428963_aural
awol75620673_a_wol
babool103012153babool
baron78131243ba_ron
barrel84517873barrel
barrow114512763barrow
batboy1387533batboy
batfowl1543593batfowl
bathos116215633bathos
baton75822423bat_on
caltrop11267633caltrop
carl65144783ca_r_l
carob95325223ca_rob
caroli85918233ca_roli
carols85124983ca_rols
carom95025563ca_rom
carrel84718633carrel
carrom10513403carrom
carrot8423123carrot
cartel85022533cartel
carton84522663carton
cartop104213563cartop
catalo8314853catalo
cation83925503cation
citral81113883citral
citron83112983citron
control9310673control
copatron1246743copatron
cuatro838413cuatro_
cuatros938253cuatros
dacron94310693dacron
dato56129943dat_o_
datos65222783dat_os
datto65416423datto_
dattos74311903dattos
diatron839283diatron
earl45838143ea_r_l
enrol51014283_enrol
estral64716513estral
estriol747553estriol
extol1247893ext_ol
farl76338553fa_r_l
faro76136923fa_ro_
faros85532023fa_ros
farrow12309973farrow
fatal84819373fat_al
fathom1437473fathom
fatso85113493fatso_
fatsos9389423fatsos
gambol1138223gambol
gaol56925413ga__ol
garron73113493garron
gastral8329553gastral
gator64416033gat_or
gators74115823gators
hadron102913753hadron
harl75740003ha_r_l
harrow122610773harrow
hartal9415473hartal
hatbox1835133hatbox
hatful12108743hatful
hatred104814333hatred
hotrod1048793hotrod
iatric8312153iatric
intro54915853intro_
intron64215023intron
intros64215773intros
jarl115828133ja_r_l
jato115822683jat_o_
jatos125116823jat_os
karoo92519583ka_roo
karroo10410013karroo
kation104315683kation
ketol95414003ket_ol
ladron73413323ladron
lateral7313563lateral
latosol745283latosol
latria62313583latria
laurel649033laurel
macro94718173macro_
macron103615673macron
macros104017013macros
maltol8310843maltol
marl66341613ma_r_l
marron83717543marron
marrow112812603marrow
matres84522233matres
matrix1539833matrix
matronal1048113matronal
matronly1344783matronly
matrons93517633matrons
matzo16312893matzo_
matzoh2035483matzoh
matzos1749263matzos
matzot17710983matzot
metol75917813met_ol
metro74718803metro_
metros84217803metros
mitral81314323mitral
narrow9269143narrow
natal53921493nat_al
nation64322803nation
natrons73215663natrons
natural739513natural
nerol51017813_nerol
nitril62511533nitril
nitro54914353nitro_
nitros64214123nitros
octroi837363octroi
outroll749303outroll
outrow9311173outrow
paction112713963paction
padre86018163padr_e
padres95016983padres
padri85815163padr_i
padrone102512073padrone
padroni10278613padroni
paeon74819493pa_eon
pagod95013683pa_god
pail66141833pa__il
pair66031513pair__
paired95017523paired
pairs75325833pair_s
pakora1247283pakora
pal56761673pa___l
paleal84716673paleal
pall65039343pa__ll
pallor8313673pallor
palpal104112053palpal
paltrily1345413paltrily
paltry114910403paltr_y
panbroil1243673panbroil
panel76023623pa_nel
panful1179743panful
panto76129413panto_
pantos85222743pantos
pantry115014103pantr_y
papal95820673pa_pal
papyral1445773papyral
par57467023pa_r__
para65242173pa_r_a
parae76335703pa_rae
paras76143043pa_ras
parasol939553parasol
parboil1138323parboil
parcel103915473parcel
parch125123003pa_rch
pard76441323pa_r_d
pardi85723953pa_rdi
pardon94618733pardon
pards85634333pa_rds
pardy115523953pa_rdy
pare66760843pa_r_e
pared86946763pa_red
pareo74632603pa_reo
pareos87023773pareos
parer75839903pa_rer
pares77164483pa_res
pareu74928743pa_reu
parge85831853pa_rge
pargo86723723pa_rgo
pargos95719043pargos
paris75145943pa_ris
park105237493pa_r_k
parka115120883pa_rka
parks116134463pa_rks
parle75836163pa_rle
parlor8312673parlor
parody12410093pa_rody
paroled104217613pa_roled
parolee94119633pa_rolee
paroles95025883pa_roles
parous84024163pa_rous
parr65731153pa_r_r
parrals94414573parrals
parred95024073parred
parrels94713493parrels
parrots9312743parrots
parroty1247863parroty
parrs75928673pa_rrs
parry105323753pa_rry
pars67560793pa_r_s
parse75236993pa_rse
parson83817903parson
part65967463pa_r_t
partan83820563partan
parted94228683parted
partial92616263partial
partly116315473partly
partons94620513partons
partook1337313partook
parts77743373pa_rts
party106630613pa_rty
parve109824853pa_rve
parvo107719183pa_rvo
parvos116614753parvos
pascal10812373pascal
paseo77022513paseo_
paseos88015813paseos
passel85117003passel
pastel85918713pastel
pastil85018323pastil
pastor84817483pastor
pastoral10310483pastoral
pastorly1345783pastorly
pastors94118993pastors
pastromi1256353pastromi
pastry114913033pastr_y
pastural1038413pastural
pat58089463pat___
pataca10311193pataca
patch125221223pat_ch
patchy16509573patchy
pate65350463pat__e
pated85237843pat_ed
patella938953patella
paten74827343pat_en
patens84820863patens
patent84524923patent
pater74740723pat_er
paternal1038333paternal
paters84935823paters
pates76047893pat_es
path99134913pat__h
paths105521383pat_hs
patin76832853pat_in
patina86022193patina
patine85328123patine
patins87528783patins
patly105020583pat_ly
patois84319363patois
patriots1038053patriots
patrolled1245713patrolled
patroller1145743patroller
patrolman1343723patrolman
patrolmen1344023patrolmen
patroons102710603patroons
pats66460853pat__s
patsy105717203pat_sy
patted94724683patted
pattee84323383pattee
patten84418193patten
patter84628263patter
pattie84020963pattie
patty104723613pat_ty
paty95234563pat__y
patzer173111643patzer
pausal81511963pausal
pavior1138533pavior
pawl95123263pa__wl
pawnor11357243pawnor
payola11208113pa_yola
payor105413843pa_yor
payors114312643payors
payrolls1344753payrolls
pearl75324463pear_l
pedro8313153pedro_
pedros9312183pedros
peril75425953p_eril
perron83216623perron
petal76526893pet_al
petiole9311303petiole
petrale9312623petrale
petrels9279373petrels
petrolic1249693petrolic
petronel1048143petronel
petrosal1047153petrosal
petrous92714423petrous
petto76021043petto_
peytral1287503peytral
peytrel1264253peytrel
pharos11312063pharos
phenol1149253phenol
phratral1344373phratral
phytol14366563phytol
pirog83913673p_irog
pistol83313333pistol
piton76121583pit_on
plastral1046913plastral
plastron1046913plastron
platoon938953platoon
plural839823plural
podsol946853podsol
podzol1835083podzol
pogrom1138593pogrom
poitrel936193poitrel
pol56449383p___ol
polyol1138713polyol
pool65835953p__ool
portal84218463portal
potboil1195463potboil
potboy1397813potboy
potful1138083potful
pothole12312173pothole
pothos114214693pothos
potion84519573potion
potto75320943potto_
pottos84615873pottos
pro55837263p__ro_
proa66229963p__roa
prod76129503p__rod
prof96134663p__rof
prog75729003p__rog
prole74527793p__role
prom87631693p__rom
prop85932813p__rop
pros65742783p__ros
prow97030383p__row
prowl105615123p__rowl
purl65631423p_ur_l
putlog965553putlog
puton73617913put_on
putrid9311163putrid
putto75617663putto_
pyro96019393p_yro_
pyrola1139003p_yrola
pyros105718293p_yros
pyrrole1246033pyrrole
pyrrols1235403pyrrols
python1447143python
ramrod936833ramrod
ratal55025113rat_al
ratel54224883rat_el
rathole10312053rathole
ratio55227583ratio_
ration64226013ration
ratios64922673ratios
rato45436973rat_o_
ratoon64417373ratoon
ratos55528763rat_os
ratton64116123ratton
retool63914483retool
retral64419743retral
retro55020953retro_
retros63820193retros
sacral83414413sacral
safrole1037253safrole
safrols1036863safrols
salol55222143sa_lol
santol64515243santol
sarod65325873sa_rod
saros55238063sa_ros
sartor6313873sartor
satori6415833satori
satrap86212553satrap
saurel6511983saurel
skatol1035713skat_ol
sotol54917643sot_ol
sparrow1234263sparrow
spathal1236263spathal
spatial9310323spatial
stanol6310723stanol
sterol6613323sterol
stool55619893_stool
stroll6311603_stroll
strop77422243_strop
strow88920573_strow
stroy87720393_stroy
tallol63612223tallol
taro46846913ta_ro_
taroc75721643ta_roc
tarok97921073ta_rok
taros55640823ta_ros
tarot55943933ta_rot
tatsoi637263tatsoi
tattoo6310973tattoo
taxol124011363ta_xol
tetryl935693tetryl
tool46735683__tool
triol55521363__triol
trod57627953__trod
trog57628213__trog
troll54416533__troll
trop66833303__trop
trot46351313__trot
trow78031423__trow
troy77429683__troy
untrod769853untrod
vagrom1235943vagrom
vatful12107083vatful
vitriol1045693vitriol
wadmol1234053wadmol
waitron1036333waitron
wastrel1037553wastrel
wittol935923wittol
yarrow12287933yarrow

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 Filter1786911127160.1731032896.0
2DLD Change Limit1127164326.67016899.0
3Display Results4324320.1403085.7
 (SQL Overall)1786914326.98325589.4
 
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.