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

188 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
pennant931249(None) 
pendant10314851pendant
pennants1037061pennants
peasant9314922peasant
peccant13311732peccant
pedant9319492pe_dant
penang92511112pe_nang
penchant1549562penchant
pendants1139092pendants
pendent10314722pendent
penman10312322penman_
penna74520202penna__
pennae84314032penna_e
penname11328552penname
pennate93314032pennate
pennine93712952pennine
penning103616492penning
pennon8310642pennon_
pennons939712pennons
pentane9415742pentane
pregnant1149882pregnant
regnant8312842regnant
remnant9312632remnant
tenant6322472te_nant
appendant1455733appendant
benignant1243983benignant
bennet84823363benn_et
bezant17814543be_zant
bezzant1746893bezzant
decant93524223de_cant
defiant11311923defiant
denning93515173denning
dependant1346993dependant
descant104315583descant
deviant11311313deviant
eluant6315093_eluant
emanant9411083emanant
enact73525363_e_nact
enchant12313103_enchant
enrapt8313013_enrapt
entrant7318873_entrant
errant6618733_errant
extant132714753_extant
fenland1135693fenland
fondant11311143fondant
gelant72821673ge_lant
gellant83214053gellant
henbane1237353henbane
henna84414043henna__
hennaed1135103hennaed
hennaing1234993hennaing
hennas94211803henna_s
incant82418503_incant
infant92315133_infant
jennet134714953jenn_et
jessant1438443jessant
kenning124010543kenning
leant56737783le__ant
lenient7313843lenient
levant9314493le_vant
mannan85413623mannan_
mannans93611523mannans
meant76537203me__ant
mediant103516703mediant
opencast1244863opencast
operant9317223ope_rant
pageant10312783pageant
pandani1039903pandani
panning104019393panning
pant66061253p___ant
passant9813943passant
pean66147173pe__an_
peans75437643pe__ans
peanut8318183pean_ut
peart76440753pe__art
peasants1038263peasants
peat65967933pe__a_t
pecan91919033pe_can_
pecans101515833pe_cans
pechan13511543pechan_
pechans14810503pechans
pedants10310113pe_dants
peening103318303peening
peining104619153peining
pekan111613973pe_kan_
pekans121710553pe_kans
peltast9310513peltast
penal75228373pe_na_l
penalty1267743pe_nalty
penance11313443penance
penangs10268373penangs
penchants1646193penchants
pendantly1545463pendantly
pendents1139413pendents
pending114119773pending
penetrant1148463penetrant
penial84120893penia_l
penitent10413503penitent
penmen10311493penmen_
pennames12287783pennames
pennated11299543pennated
penne75423853pe_n_ne
penned94217613penn_ed
penner84616663penn_er
penners93414183penners
penni74617903pe_n_ni
pennia84412973penn_ia
pennies94218813pennies
pennines103112033pennines
pennis84315743penn_is
pennoned1136313pennoned
penny105119453pe_n_ny
penpoint1249453penpoint
pent66559073pe___nt
pentad9313763penta_d
pentads1039523pentads
pentanes10316073pentanes
pentanol1046173pentanol
pentene9313793pentene
penult8314653pe_nult
peonage1048723peonage
percent113520593percent
perianth1348553perianth
periapt11313413periapt
permeant12310913permeant
perpent112318803perpent
persalt9315413persalt
petnap1037423petna_p
petnaps1145033petnaps
petulant1048793petulant
pheasant1347083pheasant
pieplant1268733pieplant
pinang92611593p_inang
pinna75320183pinna__
pinnace113510313pinnace
pinnae84414643pinna_e
pinnal84814273pinna_l
pinnas85315513pinna_s
pinnate93613743pinnate
pinning103417853pinning
pintano998993pintano
piquant1848003piquant
pissant91012503pissant
plant75437113p__lant
pleasant1048323pleasant
pliant83918823p_liant
poignant1145743poignant
ponent82821593p_onent
preenact12410183preenact
preplant12712913preplant
pulsant9310563pulsant
pungent10311233pungent
punnet83518843punn_et
punning103414993punning
reboant9315093reboant
recant83228683re_cant
reenact9413003reenact
regrant8317323regrant
reliant7319243reliant
remnants1036843remnants
rennase738713rennase
rennet64624853renn_et
rennin63914033rennin_
rennins74013413rennins
repentant1149313repentant
replant93318533replant
reptant92817073reptant
resonant8410813resonant
revenant11410273revenant
sealant73118303sealant
seawant103613413seawant
secant84023293se_cant
sejant133114483se_jant
sejeant1489723sejeant
senna54617983senna__
sennas64214233senna_s
sennet64224143senn_et
sennit63117923senn_it
servant10313623servant
setenant849923setenant
sextant142911963sextant
sonant6621953_sonant
tenants7311013te_nants
tennist72813113tennist
verdant11313293verdant
versant10313833versant
yenning11369493yenning
zenana15297983ze_nana

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271888.34616058.8
3Display Results1881880.0762473.7
 (SQL Overall)1786911888.57520838.6
 
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.