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

104 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
parous8402416(None) 
pareus85420741pareus
parlous9414291parlous
parols84722611parols
porous84419481porous
aprons8316992aprons
arcus76918862_arcus
argus66716542_argus
arouse65019982_arouse
aurous64119262aurous
barons85025382barons
bayous11411152bayous
biparous1246922biparous
carious93320282carious
carobs104818102carobs
carols85124982carols
carolus94612602carolus
caroms105619572caroms
carouse9614422carouse
carpus105514302carpus
cerous85821202cerous
famous11412392famous
faros85532022faro_s
karoos102415802karoos
kaross101910012kaross
padouk1336682padouk
padouks1434872padouks
paeons83915522paeons
pagods105310192pagods
palpus104210282palpus
pappous1057462pappous
pappus9408372pappus
paras76143042par_as
pardons103817622pardons
pards85634332par_ds
pareos87023772pareos
parers85530742parers
pares77164482par_es
pareu74928742pareu_
parges94529542parges
pargos95719042pargos
paries84742512paries
paris75145942par_is
parkas125018022parkas
parks116134462par_ks
parles86334402parles
parlors9312912parlors
parlour937262parlour
parlours1036152parlours
parodos103011752parodos
parody12410092parody
parol74826272paro_l
parole84425252parole
paroles95025882paroles
parrots9312742parrots
parrs75928672par_rs
pars67560792par__s
parses85534702parses
parsons93516872parsons
partons94620512partons
parts77743372par_ts
parvis116114802parvis
parvos116614752parvos
passus83610292passus
patois84319362patois
patrols93513512patrols
patrons93818102patrons
payors114312642payors
payout11714652payout
payouts1247302payouts
perdus93711272perdus
petrous92714422petrous
pharos11312062pharo_s
pilous84717752pilous
pious74621272p_ious
poyous112911622poyous
prahus11458242prahus
praos74923562prao_s
praus74621752p_raus
proas75028802p_roas
prods85523552p_rods
profs105120892p_rofs
progs86624152p_rogs
proms95426412p_roms
props95726882p_rops
pros65742782p_ro_s
pross76529402p_ross
proud84615482p_roud
prows106327012p_rows
pyros105718292pyro_s
ramous8417112ramous
sajous13310582sajous
sarcous9312932sarcous
sarods74918572sarods
saros55238062saro_s
serous65023562serous
tarocs84615662tarocs
taroks106115282taroks
taros55640822taro_s
tarots66422992tarots
tarsus6310512tarsus
torous64319032torous
various103113102various
varus85921182var_us

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 Filter178691825510.343520965.0
2DLD Change Limit825511042.29635954.3
3Display Results1041040.0333151.5
 (SQL Overall)1786911042.67266875.4
 
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.