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 “parol” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

126 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
parol7482627(None) 
carol75128611carol
parole84425251parole
parols84722611parols
patrol83213021patrol
apron7318832apron
argol65317262_argol
aril45843022_aril
aryl75922342_aryl
awol75620672_awol
baron78131242baron
carl65144782car_l
carob95325222carob
caroli85918232caroli
carols85124982carols
carom95025562carom
earl45838142ear_l
enrol51014282enrol
farl76338552far_l
faro76136922faro_
faros85532022faros
gaol56925412ga_ol
harl75740002har_l
jarl115828132jar_l
karoo92519582karoo
marl66341622mar_l
nerol51017812nerol
paeon74819492paeon
pagod95013682pagod
pail66141832pa_il
pal56761672pa__l
pall65039342pa_ll
panel76023622panel
papal95820672papal
par57467022par__
para65242172par_a
parae76335702parae
paras76143042paras
parasol939552parasol
parboil1138322parboil
parcel103915472parcel
parch125123002parch
pard76441322par_d
pardi85723952pardi
pardon94618732pardon
pards85634332pards
pardy115523952pardy
pare66760842par_e
pared86946762pared
pareo74632602pareo
pareos87023772pareos
parer75839902parer
pares77164482pares
pareu74928742pareu
parge85831852parge
pargo86723722pargo
pargos95719042pargos
paris75145942paris
park105237492par_k
parka115120882parka
parks116134462parks
parle75836162parle
parlor8312672parlor
parody12410092parody
paroled104217632paroled
parolee94119652parolee
paroles95025882paroles
parous84024162parous
parr65731152par_r
parral85517532parral
parrel84515982parrel
parrot8320662parrot
parrs75928672parrs
parry105323752parry
pars67560792par_s
parse75236992parse
parson83817902parson
part65967462par_t
partly116315472partly
parton84720992parton
parts77743372parts
party106630612party
parve109824852parve
parvo107719182parvo
parvos116614752parvos
patrols93513512patrols
patron84018042patron
pawl95123262pa_wl
payola11208112payola
payor105413842payor
payroll1245612payroll
pearl75324462pear_l
peril75425952peril
petrol82714062petrol
pharos11312062pharos
pirog83913672pirog
pol56449382p__ol
pool65835952p_ool
prao66229022prao_
praos74923562praos
pro55837262p_ro_
proa66229962p_roa
prod76129502p_rod
prof96134662p_rof
prog75729002p_rog
prole74527792p_role
prom87631702p_rom
prop85932812p_rop
pros65742782p_ros
prow97030382p_row
prowl105615122p_rowl
purl65631422pur_l
pyro96019392pyro_
pyrola1139002pyrola
pyros105718292pyros
pyrrol1136272pyrrol
safrol937282safrol
salol55222142salol
sarod65325872sarod
saros55238062saros
taro46846912taro_
taroc75721642taroc
tarok97921072tarok
taros55640822taros
tarot55943932tarot
taxol124011362taxol

Search took 3 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 Filter178691538000.330541487.9
2DLD Change Limit538001262.14025140.2
3Display Results1261260.0462739.1
 (SQL Overall)1786911262.51671021.9
 
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.