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

109 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
pareus8542074(None) 
pareos87023771pareos
parers85530741parers
pares77164481pare_s
pareu74928741pareu_
parous84024161parous
apres75426402apre_s
arcus76918862_arcus
areas55935772_areas
ares45871022_are_s
argus66716542_argus
aureus65314882aureus
bares75457132bare_s
carers85133952carers
cares77369182care_s
caress85720262caress
carets85330772carets
carpus105514302carpus
cereus85215522cereus
darers75921872darers
dares66146702dare_s
farers95924052farers
fares85852872fare_s
harems115513822harems
hares86255542hare_s
larees65323112larees
lares54852632lare_s
mares76457632mare_s
nares55544152nare_s
pacers105124542pacers
paces96741112pace_s
padres95016982padre_s
pagers94423252pagers
pages85235072page_s
pales75753802pale_s
palets85122312palets
palpus104210282palpus
panels84716522panels
panes76148692pane_s
papers105125322papers
pappus9408372pappus
paras76143042par_as
parcels113712662parcels
pards85634332par_ds
pare66760842pare__
pared86946762pare_d
parent83230422parent
parents93418122parents
pareo74632602pare_o
parer75839902pare_r
pareses94718872pareses
paresis93315092paresis
pareve114613012pareve
parges94529542parges
pargets105215192pargets
pargos95719042pargos
paries84742512paries
paris75145942par_is
parkas125018022parkas
parkers133816872parkers
parks116134462par_ks
parles86334392parles
parleys125212372parleys
parlous9414292parlous
parols84722612parols
parrels94713492parrels
parrs75928672par_rs
pars67560792par__s
parsecs11429912parsecs
parsers94118152parsers
parses85534702parses
parts77743372par_ts
parvenus1335652parvenus
parvis116114802parvis
parvos116614752parvos
paseos88015812paseos
pases75346502pase_s
passus83610292passus
patens84820862patens
paters84935822paters
pates76047892pate_s
pavers115021822pavers
paves104833922pave_s
pawers114818782pawers
paxes144928422paxe_s
payees114812902payees
payers114621822payers
perdus93711272perdus
peres76246642pere_s
pileus84514942pileus
pores75849032pore_s
porous84419482porous
prahus11458242prahus
praus74621752p_raus
prees75937172p_rees
preps96220692p_reps
press75425952p_ress
preys105717782p_reys
purees84721682purees
pyres105523882pyre_s
rares55247442rare_s
sarees65329942sarees
sparers94519612sparers
spares84834552spare_s
tares57456562tare_s
tarsus6310512tarsus
uraeus638792uraeus
varus85921182var_us
wares88250582ware_s

Search took 7 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.233766914.2
2DLD Change Limit825511096.31313076.4
3Display Results1091090.0631730.2
 (SQL Overall)1786911096.60927037.5
 
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.