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

163 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
pardoner1118944(None) 
pardner10239471pard_ner
pardoned12189331pardoned
pardoners12208211pardoners
gardener1037102gardener
hardener1238882hardener
padrone102512072padrone_
padrones112711042padrones
parcener1238472parcener
pardine103616722pardine_
pardners11269192pard_ners
pardon94618732pardon__
pardons103817622pardon_s
parroter1058202parroter
partner92811392par_tner
abandoner1242693abandoner
adorer74713453_a_dorer
adorner8246983_a_dorner
almoner949383_almoner
aproned10311503apr_oned
ardor64617863_ardo__r
ardour74110903_ardo_ur
armorer9259913_armorer
atoner64817193_a_toner
baronet91022203bar_onet
barrener1038333barrener
burdener1136143burdener
carder94524183card__er
cardon94120853cardon__
cardons104519943cardon_s
careener1039333careener
caroler93816753car_oler
cartoned111312833cartoned
condoner112913413condoner
cordoned12229613cordoned
coroner94218203cor_oner
crayoner1344863crayoner
crooner93714043_crooner
darkener1335993darkener
darner74017303dar__ner
droner74717673_dr_oner
earner63617223ear__ner
falconer1346043falconer
fordone1149383fordone_
gammoner1345153gammoner
gardened1137003gardened
gardeners1136603gardeners
garner73917003gar__ner
garroter956573garroter
handover15126823handover
harborer1348053harborer
hardcover1843243hardcover
hardened1338613hardened
hardeners1338083hardeners
harder105022403hard__er
hardier114721543hard_ier
harkener1537573harkener
harpooner1444333harpooner
harrower1446363harrower
ironer64216453_ir_oner
jargoned1735233jargoned
jargoneer1742753jargoneer
jargonel1643683jargonel
jawboner20133363jawboner
kroner104612573_kr_oner
ladrone83611873ladrone_
ladrones92710973ladrones
landowner1343663landowner
larcener1036493larcener
larder73720973lard__er
lardier83518343lard_ier
lardon74415063lardon__
lardons83914493lardon_s
madrone102812663madrone_
madrones112912283madrones
mariner93315993mar_iner
marooned1138563marooned
nardine82712573nardine_
narrower1145063narrower
padder103415493pa_d_der
paddler113711553pa_ddler
padroni10278613padron_i
pander93725523pand__er
panderer112210913panderer
pandoor10358583pando_or
pandore10411853pandore_
pandores11312453pandores
pandour10408213pando_ur
panner84224763pa__nner
parader103914863par_ader
parador103311413parado__r
paradores12259663paradores
paradoses122510253paradoses
paradoxes19267293paradoxes
paragoned1357063paragoned
paranoea1048573paranoea
parceners1337453parceners
pardee93922023pard__ee
pardie96021443pard_ie_
pardoning1338763pardoning
parer75839903par___er
parker124121373par__ker
parleyer1335633parleyer
parlor8312673parlo__r
parlour937263parlo_ur
parodied1238333parodied
parodies11313693parodies
parole84425253par_ole_
paroled104217633par_oled
parolee94119643par_olee
paroles95025883par_oles
paronym1437503par_onym
parrier93717653par_rier
parroket1449203parroket
parroted1158843parroted
parroters1156763parroters
parser84822373par__ser
parson83817903parson__
parsonic1239703parsonic
parsons93516873parson_s
partaker1436873partaker
partier93520713par_tier
partners102711133par_tners
parton84720993parton__
partons94620513parton_s
partyer12337873par_tyer
passover13135533passover
pawner114212923pa__wner
poisoner1046983poisoner
portioner1158683portioner
prawner1246803p_rawner
preener93114833p_reener
prisoner1048573prisoner
prober104516073p_r_ober
prodder1147953p_rodder
prone75332623p_r_one_
proofer12149103p_roofer
proper104319953p_r_oper
proser84223463p_r_oser
prover113819723p_r_over
prower114218123p_r_ower
pruner83413453p_r_uner
purloiner1143263purloiner
pyrone112714473pyr_one_
pyrones123113303pyr_ones
ratooner887003ratooner
sardine83317393sardine_
sardined10268663sardined
sardines92815573sardines
sardonic1147453sardonic
sardonyx1941453sardonyx
spadones1137253spa_dones
tardier859719993tard_ier
waggoner1343423waggoner
wagoner1136093wa_goner
wantoner1187563wantoner
warder104020273ward__er
warmonger1543853warmonger
warner93717223war__ner
warpower1645043warpower
warrener1136913warrener
yarder103813973yard__er
yarner93313063yar__ner

Search took 8 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 Limit1461621637.37619815.9
3Display Results1631630.0762144.7
 (SQL Overall)1786911637.87222699.6
 
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.