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

190 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
parbake153835(None) 
parbaked1735501parbaked
parbakes1638341parbakes
partake1339641partake
barbate11314542barbate
garbage1138052garbage
pancake1536672pancake
parable111819772parable
parade94720642par_ade
parae76335702par_a_e
parkade1437582parkade
partaken1445552partaken
partaker1436872partaker
partakes1449922partakes
prebake1539092prebake
abaka114313823_a_baka
abase76023483_a_base
abate76627843_a_bate
abrade9313053_abrade
ambage11510593_ambage
arable81821003_arable
arak86929573_ar_ak_
araks94820883_ar_aks
arame75026623_ar_ame
arbute8311043_arbute
arcade91013643_arcade
arcane81216743_arcane
areae55229743_area_e
aubade939223_aubade
awake125014783_a_wake
bake105637513___bake
barbal104016663barba_l
barbe95328283barb__e
barbie105018353barb_ie
barbule1137943barbule
barrage10710843barrage
barware12610703barware
berake124216083ber_ake
brake116025343_br_ake
cabbage1446983cabbage
carafe115416163car_afe
carate84734003car_ate
carbarn1139453carbarn
carbide126112493carbide
carbine112918643carbine
carcase11312733carcase
caretake1446773caretake
carfare12310073carfare
carmaker1637303carmaker
carnage10311743carnage
carpale113414353carpale
cartage10312593cartage
clambake1843893clambake
crake114823523_cr_ake
darbar959953darba_r
darbars10510093darbars
drake104918303_dr_ake
forbade13259103forbade
forbare122310513forbare
forsake1436533forsake
gambade1336383gambade
garage8314513gar_age
garbages1238183garbages
garbagey1543373garbagey
garbagy1444243garbagy
garble94118453garb_le
garpike1435093garpike
herbage1337003herbage
kabaka11348503ka_baka
karaoke1044903karaoke
karate105320923kar_ate
larvae938843larva_e
marble104219103marb_le
narrate7313493narrate
oarlike113411193oarlike
oatcake1345363oatcake
outbake13310773outbake
overbake17129803overbake
package16128013package
palace104516913pa_lace
palate84226783pa_late
paleae84820293palea_e
paleate94120003paleate
palmate113215233palmate
palpate113213923palpate
pancaked1734893pancaked
pancakes1637073pancakes
para65242173par_a__
parables121613563parables
paraded114014263par_aded
parader103914863par_ader
parades104121463par_ades
parakeet14410523par_akeet
parakite14410423par_akite
paramo102614643par_amo
parang93715513par_ang
parapet11317643par_apet
paraph13311263par_aph
paras76143043par_a_s
paravane1348093paravane
parbaking1877193parbaking
parboil1138323parboil
parbuckle1942103parbuckle
pardah123412823parda_h
pardahs13289673pardahs
pardee93922023par_dee
pardie96021443par_die
pardine103616723pardine
pare66760843par___e
pareve114613013par_eve
parfait12312053parfait
parge85831853par__ge
pariah114320583paria_h
pariahs123812343pariahs
parian83223963paria_n
parians93519733parians
park105237493par__k_
parka115120883par__ka
parkades1538273parkades
parkas125018023parka_s
parked134425133par__ked
parker124121373par__ker
parklike1337483parklike
parks116134463par__ks
parlance1248713parlance
parlante1039683parlante
parlay113713993parla_y
parlayed1435803parlayed
parlays123910453parlays
parle75836163par__le
parole84425253par_ole
parolee94119633parolee
parrakeet1545603parrakeet
parral85517533parra_l
parrals94414573parrals
parroket1449203parroket
parsable12311693parsable
parse75236993par__se
partakers1536563partakers
partan83820563parta_n
partans94418283partans
partite9317133partite
parure8312523par_ure
parve109824853par__ve
parvise124211693parvise
passade1039233passade
passage1039803passage
patriate10311933patriate
pavane114113443pa_vane
pawnage1335873pawnage
payable141711323payable
payback2056453payback
paybacks2145493paybacks
percale11314083percale
peruke123210393per_uke
pervade1337023pervade
phrase11109903phr_ase
phreak1536153phreak_
phreaked1834493phreaked
phreaker1735053phreaker
phreaks1634543phreaks
pikake11115803p_ikake
pirate82322883pir_ate
portage103013643portage
prase76128753p_r_ase
prate75135983p_r_ate
prebade12310283prebade
prebaked1737173prebaked
prebakes1639003prebakes
probate11414483probate
rake84841573__r_ake
sambuke1544203sambuke
sarape84817573sar_ape
sorbate9311733sorbate
sparable121611973sparable
sparlike1437663sparlike
strake104017393str_ake
surbase939793surbase
tambak14249263tambak_
tambaks15218153tambaks
tartare73012683tartare
unbrake13239123unbrake
urbane82211383_urbane
variate101316433variate
warble113516603warb_le
warfare1336733warfare
warlike142410473warlike
warmaker1735973warmaker
warpage1336403warpage
yardage1235733yardage

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 Filter1786911340270.1731032896.0
2DLD Change Limit1340271907.00019146.7
3Display Results1901900.0633015.9
 (SQL Overall)1786911907.23624694.7
 
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.