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

162 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
penanced133816(None) 
penance11313441penance_
penances12312441penances
enhanced1436622_enhanced
financed1435112financed
menaced122710092mena_ced
peaced115818912pe_a_ced
pennated11299542pennated
penned94217612pen_n_ed
penoncel1244842penoncel
pranced123714042p_ranced
tenanted937042tenanted
advanced1543313advanced
balanced1356513balanced
beaned95621473be_an_ed
bechanced1945643bechanced
bedunced1453903bedunced
belaced124112153bela_ced
benamed122911093bena_med
chanced154113213_chanced
danced105315253__danced
deaned84620453de_an_ed
decanted122310493decanted
defaced142910973defa_ced
defanged1435433defanged
defenced1537203defenced
demanded13348513demanded
denned84215633den_n_ed
denounced1344033denounced
deranged1137693deranged
desanded11227453desanded
dezinced2183903dezinced
enabled102510633_enabled
enacted10310643_enacted
enfaced13218913_enfaced
enhance1239693_enhance_
enhancer1346683_enhancer
enhances1339293_enhances
enlaced102410523_enlaced
enounced1135883_enounced
enticed101411193_enticed
entranced1247393_entranced
evinced1335403_evinced
fenagled13184853fenagled
fenced124412713fe__nced
finance1238573finance_
finances1338653finances
glanced11439233_glanced
hennaed1135103hen_naed
jeaned143813463je_an_ed
kenned114411273ken_n_ed
lanced93717723__lanced
leaned73422543le_an_ed
levanted1245323levanted
menace103216943mena_ce_
menacer112610883mena_cer
menaces112715523mena_ces
nance74721843__nance_
nances83618643__nances
nuanced1036203_nuanced
openhanded1752243openhanded
paced106931683p__a_ced
palaced124110783pala_ced
panacea1137793pana_cea
paned85437183p__an_ed
panged104722333p__anged
panned94123433p__anned
panted95024823p__anted
peace95026083pe_a_ce_
peaces106324083pe_a_ces
peached154315883pe_ached
peaked136117403pe_a_ked
pealed95322813pe_a_led
pearled10411553pe_arled
peascod1244073pe_ascod
pedaled113711893peda_led
pedalled1246933pedalled
peduncled1542523peduncled
peened94318163pe_en_ed
peined94918843pe_in_ed
penalised12108833penalised
penalized211210243penalized
penancing1436343penancing
penang92511113penan__g
penangs10268373penan_gs
penates93321603pena_tes
pence94924453pe__nce_
pencel103812913pe__ncel
penciled1337823penciled
pended103819013pe__nded
pennae84314033pen_nae_
penname11328553penname_
pennames12287793pennames
pennate93314033pennate_
penne75423853pen_n_e_
penner84616663pen_n_er
pennies94218813pen_nies
pennoncel1343253pennoncel
pennoned1136313pennoned
penoncels1343593penoncels
pentane9415743pentan_e_
pentanes10316083pentan_es
peracid12312993pera_cid
petaled103614153peta_led
petalled1138713petalled
petnapped1342383petnapped
pinnace113510313pinnace_
pinnaces12268863pinnaces
pinnacled14304503pinnacled
pinnated11338553pinnated
pinned94818383pin_n_ed
placed114318003p_la_ced
planed94420913p_lan_ed
planked143512283p_lanked
planned103810153p_lanned
planted103516123p_lanted
ponced114314813p__onced
pounced123510623p_ounced
prance104318573p_rance_
prancer113613383p_rancer
prances113618773p_rances
pranged114512553p_ranged
pranked143712093p_ranked
precancel1546203precancel
precancer1547093precancer
prefaced1638423prefa_ced
prefinanced1983183prefinanced
prenticed14118063prenticed
punned93416193pun_n_ed
recaned102817203recan_ed
recanted112513513recanted
refaced133713573refa_ced
refenced1438993refenced
refinanced16144763refinanced
rehanged1357833rehanged
relaced103517213rela_ced
relanded102410463relanded
remanded123011323remanded
remanned11319353remanned
renailed92512803renailed
renamed103114523rena_med
renounced1245923renounced
romanced1337253romanced
seance83716693se_ance_
seances93015343se_ances
sentenced1256683sentenced
sonance9310313sonance_
sonances10310263sonances
speaned103411523spe_an_ed
tenace82715693tena_ce_
tenaces92814513tena_ces
tenancies1149173tenancies
tenancy1237503tenanc_y
tendance1147523tendance_
tendances1247573tendances
tenoned839363tenon_ed
tranced104414173_tranced
unnuanced1243413unnuanced
valanced1475463valanced
weaned103816153we_an_ed
yeaned103813903ye_an_ed
yenned10409383yen_n_ed

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.423422437.4
2DLD Change Limit1461621627.62319173.8
3Display Results1621620.0632571.4
 (SQL Overall)1786911628.10922036.1
 
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.