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

351 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
dunnest8331226(None) 
dunness8298981dunness
funnest102912001funnest
dankest122611672dankest
densest83112472densest
donnert82815522donnert
drunkest1334422drunkest
dueness82310122dueness
dullest8312632dullest
dulness8307982dulness
dumbest1238742dumbest
dunces95215752dunces_
dunes65332172du_nes_
dungiest102810742dungiest
dunned85015522dunne_d
dunner73913822dunne_r
durndest1065762durndest
funest94316862fu_nest
funfest13348082funfest
funniest113010732funniest
luniest73516992luniest
puniest92918092puniest
punkest132611692punkest
punnet83518842punne_t
punnets9409262punnets
punniest102511582punniest
runniest82911202runniest
sunniest82712902sunniest
tannest72617852tannest
unrest62918852_unrest
wannest103915002wannest
anenst63514983_anenst
auldest839893auldest
bannet84925333banne_t
bannets94013843bannets
bennes86019013bennes_
bennet84823363benne_t
bennets94712163bennets
bluntest1036553bluntest
boniest93318993boniest
bonnes85621453bonnes_
bonnet85524633bonne_t
bonnets94812803bonnets
bonniest10310773bonniest
buffest15298633buffest
bummest13298623bummest
bundist10310193bundist
bunnies94415003bunnies_
bunns74718293bunn_s_
burnet84326173burne_t
burnets93813263burnets
busiest93716303busiest
canniest10313363canniest
congest104618773congest
connect113515743connect
contest93523233contest
cunner83915003cunne_r
cunners93913463cunners
curtest9713963curtest
cutest85820143cu_test
daftest11248943daftest
damndest1276003damndest
dampest12411043dampest
dances95120653dances_
dandiest103415033dandiest
dankness13256693dankness
darkest122512623darkest
darndest1067223darndest
daubiest1138233daubiest
deadest93014883deadest
deafest112911513deafest
dearest83618673dearest
deepest10310443deepest
deffest14308803deffest
deftest112611713deftest
denes65639723d_enes_
denies74729643denies_
denned84215633denne_d
dentist8316743dentist
detest74122843d_etest
devest104418703d_evest
dewiest11312343dewiest
diciest103316523diciest
dienes75719903dienes_
digest84019623d_igest
dimmest1249253dimmest
dimness1038843dimness
dines66449153d_ines_
dinges83825423dinges_
dingiest102915363dingiest
dinkiest133812873dinkiest
dinned84317613dinne_d
dinner74217153dinne_r
dinners83915433dinners
dipnet91317473dipne_t
dipnets10109033dipnets
direst75024243d_irest
divest106820073d_ivest
divinest123012173divinest
doest65829523d__oest
donees74519493donees_
doneness9411513doneness
donnas75511323donnas_
donne65520463donne__
donned85015743donne_d
donnee74317063donne_e
donnees84210363donnees
donnerd9427813donnerd
donnish11187633donnish
dopiest103315993dopiest
dotiest83717453dotiest
dourest8312943dourest
dourness947683dourness
downiest122710603downiest
doziest174012473doziest
drest65530343d__rest
driest74722753d_riest
drones75023433drones_
dryest104811123d_ryest
dryness11114783dryness
dualist8614053dualist
dubonnet1144813dubonne_t
dubonnets1242133dubonnets
duces86327473du_ces_
duchess1335553duchess
duckiest153211863duckiest
dudes75424373du_des_
duelist8511413duelist
duendes938193duendes_
duennas834143duennas_
dues56045503du__es_
duet56446263du__e_t
duets65323883du__ets
dukes105023473du_kes_
dulcet9314493dulce_t
dulcets1046283dulcets
dullness934873dullness
dulses73913653dulses_
dumbness1334613dumbness
dumpiest1338743dumpiest
dunams937833dunams_
dunce86319263dunce__
dunches133312583dunches_
duncish1335793duncish
dune56137583du_ne__
dunged95414693dunge_d
dungeon9134553dungeon
dungs75821973du_ngs_
dunites8313593dunites_
dunked124315283dunke_d
dunker113616463dunke_r
dunkers123512193dunkers
dunks105621193du_nks_
dunnage9175213dunnage
dunnages10154933dunnages_
dunnesses1037693dunnesses
dunning93514473dunning
dunnite857333dunnite
dunnites947173dunnites_
duns55140433du_n_s_
dunt55746873du_n__t
dunted84718503dunte_d
dunts65828413du_nts_
dupes86425933du_pes_
dures65635923du_res_
duress74712063du_ress
durmast1037623durmast
durned84113173durne_d
durnedest1144083durnedest
durns64819863durn_s_
durst66125173du__rst
duskiest133710083duskiest
dust57142533du___st
dustiest93015073dustiest
duties74921903duties_
duvet9321873du_ve_t
duvets1039223du_vets
dwines105013103dwines_
dynast1088223d_ynast
dynes95917583d_ynes_
earnest7318733earnest
evenest10312103evenest
fainest10417703fainest
fenniest113113203fenniest
finest94321733_finest
finniest113011403finniest
fondest11312403fondest
fullest10313343fullest
fulness10248963fulness
fumiest12312193fumiest
funfests14253563funfests
funkiest152810973funkiest
funned103613953funne_d
funnel93610743funne_l
funnels10348173funnels
funner93414103funne_r
funnies104113603funnies_
gannet74321853ganne_t
gannets83811443gannets
gauntest936603gauntest
ginniest92610503ginniest
guest65225923gu__est
gunkiest132610573gunkiest
gunless8299633gunless
gunned83513093gunne_d
gunnel73411053gunne_l
gunnels8358563gunnels
gunnen7338713gunne_n
gunner73813983gunne_r
gunners83111723gunners
gunnery11376363gunnery
gunnies83413123gunnies_
gurnet74920873gurne_t
gurnets84010793gurnets
hangnest12311413hangnest
honest94822423_honest
hugest10311763hu_gest
humanest1348123humanest
hunkiest153812333hunkiest
hunnish1336163hunnish
inanest72115363inanest
incest82918743_incest
infest93315433_infest
ingest73119003_ingest
invest93014843_invest
jennet134714953jenne_t
jennets14517633jennets
junket173815023junke_t
junkets18377623junkets
junkiest192610173junkiest
justest1449893justest
keenest11410963keenest
kindest12311503kindest
lankest112714113lankest
leanest7415863leanest
liniest73321153liniest
linnet6419413linne_t
linnets739823linnets
longest84114953longest
lunes55337773lu_nes_
lunet56835423lu_ne_t
lunets66914763lu_nets
lunges76123423lunges_
lunies64723013lunies_
lushest103312283lushest
meanest9315703meanest
murkest133110203murkest
mutest84218053mu_test
nest45548733___nest
nudest74113833nu_dest
numbest1138793numbest
nunnery10355293nunnery
nunnish1035933nunnish
openest9312913openest
ounces83617773ounces_
pannes85522853pannes_
piniest93121133piniest
pinkest132812623pinkest
pungent10311233pungent
puniness101610273puniness
punkiest149312663punkiest
punned93416193punne_d
punner84918153punne_r
punners94114233punners
purest84021933pu_rest
quest144121323qu__est
rankest112713813rankest
renest64529713_renest
rennet64624853renne_t
rennets75212633rennets
roundest9310473roundest
rubiest92914423rubiest
rudest74016313ru_dest
ruliest72816423ruliest
rummest11279833rummest
runes55530223ru_nes_
runless72810423runless
runlet63821413runle_t
runlets73310773runlets
runnel63510663runne_l
runnels7329153runnels
runner63814463runne_r
runners74212453runners
runtiest83014513runtiest
sanest64426693_sanest
sennet64224143senne_t
sennets73712583sennets
sonnet65923503sonne_t
sonnets74211993sonnets
soonest7415593soonest
soundest9510973soundest
suavest10310623suavest
subnet82520933subne_t
subnets92512083subnets
subtest9513963subtest
suggest9310863suggest
sunbelt939233sunbelt
sunfast1038503sunfast
sunket103721363sunke_t
sunkets113511283sunkets
sunless73013693sunless
sunnas63914563sunnas_
sunned74216323sunne_d
sunns55017353sunn_s_
sunset63723633sunse_t
sunsets72911573sunsets
surest65026763su_rest
tennist72813113tennist
tensest72713313tensest
thinnest11248883thinnest
tiniest73020123tiniest
tinniest82911463tinniest
toniest73218903toniest
tonnes65320853tonnes_
tunes55332193tu_nes_
tunned74014493tunne_d
tunnel64310633tunne_l
tunnels7328723tunnels
tunnies73614263tunnies_
unbelt83015693_unbelt
unbent83216593_unbent
unblest9411813_unblest
uncast84215713_uncast
undrest8313013_undrest
unfelt92413463_unfelt
unjust1337873_unjust
unkent103116053_unkent
unkept123710873_unkept
unless62413073_unless
unlet54133333_unle_t
unmeet83815743_unmeet
unmesh1145793_unmesh
unmet74426393_unme_t
unpent83117373_unpent
unrent63219783_unrent
unrests7229463_unrests
unseat64221023_unseat
unsent63820963_unsent
unset54532433_unse_t
unsets64116163_unsets
unvext1658173_unvext
unwept11389813_unwept
unwet84423173_unwe_t
vainest10315763vainest
viniest103216613viniest
waniest103819113waniest
wanness102610683wanness
wenniest11259593wenniest
winiest103419693winiest
youngest1244903youngest
zaniest163214773zaniest

Search took 6 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.1561145455.1
2DLD Change Limit1340273515.64023763.7
3Display Results3513510.1262785.7
 (SQL Overall)1786913515.92230174.1
 
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.