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

116 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
parbaking187720(None) 
partaking1698671partaking
pancaking1836382pancaking
parading12313862par_ading
parawing14310582par_awing
parking143423042par__king
parlaying1537302parlaying
phreaking1936472phreaking
prebaking1838062prebaking
abasing10610673_a_basing
abating10413973_a_bating
abrading1239503_abrading
arcading1239763_arcading
arcking145811963_ar_cking
arraying1238753_arraying
awaking1547813_a_waking
baking135626623___baking
barbering14229683barbering
barbing123716993barb__ing
barking144724183bar__king
barracking1944713barracking
barraging1337383barraging
beraking153612973ber_aking
braking143917713_br_aking
breaking153914253_breaking
cabbaging1744093cabbaging
carbamino1545473carbamino
caretaking1765333caretaking
carjacking2643543carjacking
carking144322853car__king
creaking153414123_creaking
croaking153712163_croaking
darking134217343dar__king
earmarking1743583earmarking
forsaking1745173forsaking
freaking163611453_freaking
garaging1139043gar_aging
garbing113613273garb__ing
garbling12249453garb_ling
harboring1538263harboring
harking154120943har__king
kayaking1534063ka_yaking
lariating10311783lariating
larking123718253lar__king
lawmaking1943943lawmaking
mapmaking2044623mapmaking
marbling13179883marb_ling
marking144020133mar__king
narking124015383nar__king
narrating10310353narrating
outbaking1638233outbaking
overbaking2067773overbaking
pacemaking2144383pacemaking
packaging1945163packaging
packing164420723pa__cking
paiking143814813pa__iking
palpating1438533palpating
panicking1835293panicking
papermaking2253723papermaking
parakite14410423par_akite
parang93715513par_a__ng
parasang1147333par_asang
parawings1535823par_awings
parbake1538353parbak__e
parbaked1735503parbak_ed
parbakes1638343parbak_es
parboiling1545173parboiling
parbuckling2251463parbuckling
parceling1438443parceling
parching164313053par_ching
pardoning1338763pardoning
parenting12611583parenting
pargeting1338283pargeting
parging113318603par__ging
paring94236493par___ing
parkings153610683par__kings
parleying1536113parleying
parling103823763par__ling
parodying1655423parodying
paroling113316213par_oling
parring103222063par__ring
parroting1239153parroting
parrying14168133par_rying
parsing103819553par__sing
partaken1445553partaken_
parting103527383par__ting
partying14168893par_tying
passaging1345613passaging
patriating13510203patriating
peaking144317693p__eaking
perking143716463per__king
pervading1636303pervading
phrasing1438013phr_asing
phreakings2043193phreakings
pirating11314513pir_ating
playmaking2243393playmaking
porking143515813por__king
portaging1346843portaging
pranking153813383p_ranking
prating103424453p_r_ating
praying133717323p_r_aying
pricking173212603p_ricking
prinking153212453p_rinking
probating14311193probating
raking114728423__r_aking
sambaing1337113samba_ing
screaking16228233screaking
sparking152812543spar__king
streaking142010323streaking
tarmacking1944233tarmacking
troaking133310973_troaking
unbraking1636933unbraking
variating13310943variating
warbling14198943warb_ling
warking153519573war__king
wreaking163010213_wreaking

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411166.69022218.4
3Display Results1161160.0601933.3
 (SQL Overall)1786911167.18624866.5
 
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.