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

117 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
parols8472261(None) 
carols85124981carols
parol74826271parol_
parole84425251parole
paroles95025881paroles
parous84024161parous
patrols93513511patrols
aprons8316992aprons
argols74514612_argols
arils58732202_arils
aryls87015812_aryls
awols84713522_awols
barons85025382barons
carls77037422car_ls
carobs104818102carobs
carol75128612carol_
caroli85918232caroli
carolus94612602carolus
caroms105619572caroms
earls56127512ear_ls
enrols61213382enrols
farls85731112far_ls
faros85532022faro_s
gaols66717572ga_ols
harls85634502har_ls
jarls126120962jar_ls
karoos102415802karoos
kaross101910012kaross
marls75535162mar_ls
nerols6914882nerols
paeons83915522paeons
pagods105310192pagods
pails75833062pa_ils
palls74332562pa_lls
pals66951352pa__ls
panels84716522panels
paras76143042par_as
parasols1039262parasols
parboils1237432parboils
parcels113712662parcels
pardons103817622pardons
pards85634332par_ds
pareos87023772pareos
parers85530742parers
pares77164482par_es
pareus85420742pareus
parges94529542parges
pargos95719042pargos
paries84742512paries
paris75145942par_is
parkas125018022parkas
parks116134462par_ks
parle75836162par_le
parles86334402parles
parlor8312672parlor
parlors9312912parlors
parlous9414292parlous
parodos103011752parodos
parody12410092parody
paroled104217632paroled
parolee94119642parolee
parolees104313982parolees
parrals94414572parrals
parrels94713492parrels
parrots9312742parrots
parrs75928672par_rs
pars67560792par__s
parses85534702parses
parsons93516872parsons
partly116315472partly
partons94620512partons
parts77743372par_ts
parvis116114802parvis
parvos116614752parvos
patois84319362patois
patrol83213022patrol_
patrons93818102patrons
pawls105617662pa_wls
payola11208112payola
payolas12148972payolas
payors114312642payors
payroll1245612payroll
payrolls1344752payrolls
pearls84715392pear_ls
perils84121852perils
petrols92913082petrols
pharos11312062pharo_s
pols66044562p__ols
pools74427702p_ools
porous84419482porous
praos74923562prao_s
proas75028802p_roas
prods85523552p_rods
profs105120892p_rofs
progs86624152p_rogs
prole74527792p_role
proles84627202p_roles
proms95426412p_roms
props95726882p_rops
pros65742782p_ro_s
pross76529402p_ross
prowls115511082p_rowls
prows106327012p_rows
purls74723352pur_ls
pyrola1139002pyrola
pyrolas1239862pyrolas
pyros105718292pyro_s
pyrrols1235402pyrrols
safrols1036862safrols
salols64017872salols
sarods74918572sarods
saros55238062saro_s
tarocs84615662tarocs
taroks106115282taroks
taros55640822taro_s
tarots66422992tarots
taxols13328632taxols

Search took 4 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 Filter178691825510.376475242.0
2DLD Change Limit825511173.46623817.4
3Display Results1171170.0801462.5
 (SQL Overall)1786911173.92245561.2
 
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.