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

145 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
parbaked173550(None) 
parbake1538351parbake_
parbakes1638341parbakes
pancaked1734892pancaked
paraded114014262par_aded
parked134425142par__ked
parlayed1435822parlayed
partake1339642partake_
partaken1445552partaken
partaker1436872partaker
partakes1449922partakes
phreaked1834492phreaked
prebaked1737172prebaked
abased96514993_a_based
abated95918453_a_bated
abraded1138643_abraded
arbored103811603_arbored
arcaded1178973_arcaded
arcked136211943_ar_cked
arrased8149863_arrased
arrayed11117153_arrayed
awaked14579203_a_waked
baked126130773___baked
barbate11314543barbate_
barbed115121313barb__ed
barbered13259543barbered
barebacked2143273barebacked
barked135027313bar__ked
barracked1844753barracked
barraged1297683barraged
beraked144312433ber_aked
braked135318693_br_aked
cabbaged1644383cabbaged
carboyed1637183carboyed
carjacked2543353carjacked
carked134024823car__ked
carmaker1637313carmaker
creaked143413233_creaked
croaked143710533_croaked
darked123919633dar__ked
earmarked1643223earmarked
freaked15399703_freaked
garaged1039253gar_aged
garbage1138053garbage_
garbages1238183garbages
garbagey1543373garbagey
garbed104815663garb__ed
garbled114512803garb_led
harbored1438633harbored
harked145422553har__ked
herbaged1554523herbaged
kayaked1474053ka_yaked
lariated91212063lariated
larked114519473lar__ked
marbled123212113marb_led
marked133921623mar__ked
narked114116743nar__ked
narrated9310323narrated
outbaked1538393outbaked
overbaked19127833overbaked
packaged18115753packaged
packed154822603pa__cked
paiked135113433pa__iked
palaced124110773pa_laced
palmated132511003palmated
palpated13249763palpated
pancake1536673pancake_
pancakes1637073pancakes
panicked1785173panicked
paperbacked2452323paperbacked
parable111819773parable_
parables121613563parables
parade94720643par_ade_
parader103914863par_ader
parades104121463par_ades
parae76335703par_a_e_
parakeet14410523par_akeet
parapet11317643par_apet
parbaking1877203parbaking
parboiled1445223parboiled
parbuckled2151583parbuckled
parceled1338343parceled
parched154013693par_ched
pardoned12189333pardoned
pared86946763par___ed
parented11912213parented
parged104922043par__ged
pargeted1238683pargeted
parkade1437583parkade_
parkades1538273parkades
parker124121373par__ker
parled94626293par__led
parleyed1436243parleyed
parodied1238333parodied
paroled104217633par_oled
parrakeet1545603parrakeet
parred95024073par__red
parried103615723par_ried
parroket1449203parroket
parroted1158843parroted
parsed96323893par__sed
parslied1137823parslied
partakers1536563partakers
parted94228683par__ted
partied103516553par_tied
passaged1236243passaged
patriated1238533patriated
peaked136117403p__eaked
perked134617693per__ked
peruked14367893per_uked
pervaded1535373pervaded
phrased1387383phr_ased
phreaker1735053phreaker
pirated102515613pir_ated
porked134717623por__ked
portaged12228463portaged
portaled11239203portaled
pranked143712093p_ranked
prated94924923p_r_ated
prayed124815433p_r_ayed
preaged11612333p_reaged
prebake1539093prebake_
prebakes1639013prebakes
pricked164613833p_ricked
prinked143412163p_rinked
probated13410863probated
raked105831423__r_aked
sambaed1238303samba_ed
screaked15246983screaked
sparked143513143spar__ked
straked125415343str_aked
streaked13228453streaked
sunbaked1545533sunbaked
surbased1136613surbased
tarmacked1843773tarmacked
troaked12438253_troaked
turbaned1145623turbaned
unbaked143312893_unbaked
unbraked15289413unbraked
unraked122914013unr_aked
variated121211393variated
warbled133212163warb_led
warked144421213war__ked
warmaker1735973warmaker
wreaked15369023_wreaked

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.406440125.6
2DLD Change Limit1461621456.98320931.1
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.45223978.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.