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

101 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
parleyer133563(None) 
parleyed1436241parleyed
parleyers1444701parleyers
parcener1238472parcener
parlayed1435822parlayed
parley116718362parley__
parleys125212372parley_s
parsleyed1543352parsleyed
partyer12337872par_tyer
preyer114413732p_r_eyer
allayer10148213_allayer
alleger8319633_alleger
arrayer10136703_arrayer
barley115116763barley__
barleys125011843barley_s
barrener1038343barrener
barterer102711653barterer
caloyer1238143ca_loyer
careener1039333careener
career85822243car_e_er
careerer1038583careerer
darkener1335993darkener
darneder1033983darneder
earlier72612743earl_ier
gardener1037113gardener
greyer104510093_gr_eyer
hardener1238883hardener
harkener1537573harkener
larcener1036493larcener
marketer1437383marketer
marlier92614783marl_ier
motleyer1343263motleyer
palaver1238753pa_laver
paleae84820293pa_leae_
paler75436933pa_l__er
palier85023563pa_l_ier
palleted1139873palleted
pallier94417163pa_llier
palmer105816543pa_l_mer
palmier113312173pa_lmier
palter84423263pa_l_ter
palterer102411293palterer
pamperer14228333pamperer
panderer112210913panderer
paperer113111903pa_perer
parader103914863par_ader
paralyzer2344483paralyzer
parameter1349123parameter
parceled1338343parceled
parceners1337463parceners
pardee93922023parde_e_
pardner10239473par_dner
pardoner11189443pardoner
parer75839903par___er
pareses94718883par_eses
pareve114613013par_eve_
pargeted1238683pargeted
parietes10714543parietes
parker124121373par__ker
parlay113713993parlay__
parlays123910453parlay_s
parle75836163parl__e_
parled94626293parl__ed
parles86334403parl__es
parleying1536113parleying
parlor8312673parl__or
parlour937263parl_our
parolee94119653parole_e_
parolees104313983parole_es
parrier93717653par_rier
parroter1058213parroter
parser84822373par__ser
parsley1247803parsley__
parsleys1335083parsley_s
partaker1436873partaker
parterre1037013parterre
partier93520713par_tier
partner92811393par_tner
partyers13277763par_tyers
patterer103112183patterer
payer105125723pa___yer
pearler9310373pearl__er
pearlier1037323pearl_ier
perplexer2042753perplexer
player115215213p__layer
plyer106214333p__l_yer
prayer114815293p_r_ayer
preener93114833p_reener
prefer113813203p_r_efer
preyed125313203p_r_eyed
preyers124412363p_r_eyers
pryer104415313p_r__yer
purveyed1743363purveyed
purveyor1641543purveyor
valleyed1534013valleyed
volleyer1443163volleyer
walleye1336243walleye_
walleyed1534153walleyed
walleyes1435603walleyes
warrener1136923warrener
waylayer1743153waylayer

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621017.72018932.9
3Display Results1011010.0462195.7
 (SQL Overall)1786911018.18621828.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.