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

473 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
tannest7261785(None) 
wannest103915001wannest
anenst63514982_anenst
bannet84925332banne_t
bannets94013842bannets
canniest10313362canniest
dankest122611672dankest
dunnest83312262dunnest
earnest7318732earnest
fainest10417702fainest
funnest102912002funnest
gannet74321852ganne_t
gannets83811442gannets
hangnest12311412hangnest
inanest72115362inanest
lankest112714112lankest
pannes85522852pannes_
rankest112713812rankest
sanest64426692sa_nest
tallest7317092tallest
tamest85721292ta_mest
tangent8314992tangent
tangiest92915222tangiest
tanist6324592ta_nist
tanned75219952tanne_d
tanner63722282tanne_r
tanners74018392tanners
tannery10388652tannery
tannish101610572tannish
tartest72517532tartest
tautest72612442tautest
tawniest11279342tawniest
tennist72813112tennist
tensest72713312tensest
thinnest11248882thinnest
tiniest73020122tiniest
tinniest82911462tinniest
toniest73218902toniest
tonnes65320852tonnes_
trapnest10310922trapnest
vainest10315762vainest
waniest103819112waniest
wanness102610682wanness
zaniest163214772zaniest
ablest84721833_ablest
acnes75922623_acnes_
airest63825263_airest
amnesty1244823_amnesty
anapest9311553_anapest
anent54931843_a_nent
anes45255933_a_nes_
angst6415493_a_ngst
annas55824883_annas_
anneal64812293_anneal
annex12310883_anne_x
annexe1337813_annexe
antes56334323_antes_
aptest82917513_aptest
arrest63722633_arrest
atones65225773atones_
attest62618613_attest
babiest114414753babiest
baddest112611143baddest
badness1039573badness
baldest102313533baldest
banes74945583ba_nes_
banned94721343banne_d
banner84421503banne_r
banneret102412473banneret
banners94018713banners
banns75321233bann_s_
barest85327693ba_rest
barniest104815053barniest
basest84720493ba_sest
bennes86019013bennes_
bennet84823363benne_t
bennets94712163bennets
blandest113811043blandest
blankest14439063blankest
boniest93318993boniest
bonnes85621453bonnes_
bonnet85524633bonne_t
bonnets94812803bonnets
bonniest10310773bonniest
branniest11199383branniest
cagiest102916433cagiest
cakiest133215663cakiest
calmest11312343calmest
candent10417363candent
canes75350373ca_nes_
canines93724033canines_
cannas84518403cannas_
canned95022063canne_d
cannel84216403canne_l
cannels93413363cannels
canner84625983canne_r
canners93822663canners
cannery123610003cannery
cannot83616773cann_ot
canoeist10310693canoeist
canoes84725883canoes_
canoness1039393canoness
canonist10513533canonist
canst74932213ca_n_st
carnet84732873carne_t
carnets93918403carnets
congest104618773congest
connect113515743connect
contest93523233contest
crankest1438143crankest
daftest11248943daftest
damndest1276003damndest
dampest12411043dampest
dances95120653dances_
dandiest103415033dandiest
dankness13256693dankness
darkest122512623darkest
darndest1067223darndest
densest83112473densest
donnert82815523donnert
dunness8298983dunness
earnests837853earnests
easiest72318773easiest
evenest10312103evenest
fabbest1438033fabbest
faintest1139073faintest
fairest10412293fairest
falsest10310013falsest
fanciest133612713fanciest
fanes84639893fa_nes_
fanjet16311393fanje_t
fanjets1734803fanjets
fanned104117473fanne_d
fanner94218183fanne_r
fanners103914653fanners
fannies103415643fannies_
fantast10311703fantast
farness102912203farness
fastest102413723fastest
fatness103311293fatness
fattest102913063fattest
fawniest14287443fawniest
fenniest113113203fenniest
finest94321733_finest
finniest113011403finniest
fondest11312403fondest
frankest1536963frankest
funest94316863_funest
funfest13348083funfest
funniest113010733funniest
gabfest1336453gabfest
gainst74914693gain_st
gamest94919923ga_mest
gamiest102816223gamiest
garnet73928413garne_t
garnets84115403garnets
gashest114813413gashest
gauntest936603gauntest
gayest104314333ga_yest
gayness1136843gayness
ginniest92610503ginniest
grandest10311573grandest
haddest122711993haddest
halest94823273ha_lest
hances115621283hances_
handiest123417773handiest
handset113016823handset
hangnests1344543hangnests
hanses95022633hanses_
hardest113118413hardest
harness102413933harness
harvest132112753harvest
haziest193313003haziest
honest94822423_honest
inanes62519803inanes_
incest82918743_incest
infest93315433_infest
ingest73119003_ingest
invest93014843_invest
janes124928123ja_nes_
jennet134714953jenne_t
jennets14517633jennets
joannes1436243joannes_
kanes95529373ka_nes_
keenest11410963keenest
kindest12311503kindest
laciest93819033laciest
lakiest113517263lakiest
lamest84722763la_mest
lances84824103lances_
lancet84223573lance_t
lancets93411163lancets
lanes54946793la_nes_
lankiest122912493lankiest
lankness12237043lankness
lanner64920593lanne_r
lanneret82512353lanneret
lanners73618323lanners
largest83715103largest
latest63822703la_test
laxest134913363la_xest
laxness1436043laxness
laziest163814473laziest
leanest7415863leanest
leanness837373leanness
liniest73321153liniest
linnet6419413linne_t
linnets739823linnets
longest84114953longest
luniest73516993luniest
maddest112311213maddest
madness10310073madness
magnet9320663magne_t
magnets10311143magnets
manes76648953ma_nes_
manges94628943manges_
mangiest112815903mangiest
manifest1339503manifest
manless93012933manless
manliest102314943manliest
mannas85019803mannas_
manned94418643manne_d
manner84020513manne_r
mannerist1149093mannerist
manners93417833manners
mannish121710693mannish
mannose939243mannose
manses84225513manses_
mantes84430783mantes_
matiest92522453matiest
mayest114614793ma_yest
maziest183613873maziest
meanest9315703meanest
meanness1037183meanness
naivest10309473naivest
nances83618643nances_
nannies73015203nannies_
nest45548733___nest
oakiest112913923oakiest
onanist7314633onanist
openest9312913openest
paciest112917803paciest
palest83926223pa_lest
paliest93021603paliest
pandect12310953pandect
panes76148693pa_nes_
panne76623653panne__
panned94123433panne_d
panner84224763panne_r
panners93621273panners
patness92912283patness
piniest93121133piniest
pinkest132812623pinkest
plainest10313613plainest
puniest92918093puniest
punkest132611693punkest
punnet83518843punne_t
punnets9409263punnets
punniest102511583punniest
raciest92820013raciest
rainiest81214923rainiest
rances84625443rances_
randiest93418773randiest
ranees64623963ranees_
ranges73826923ranges_
rangiest93115983rangiest
rankness12267943rankness
rarest65725483ra_rest
rashest103916873rashest
rawest93615063ra_west
rawness1038153rawness
renest64529713_renest
rennet64624853renne_t
rennets75212633rennets
runniest82911203runniest
saddest92412383saddest
sadness8310613sadness
safest95016603sa_fest
sagest74920263sa_gest
sagiest82617983sagiest
saltest71916513saltest
sandiest93218683sandiest
saneness82313723saneness
sanes55649073sa_nes_
sanies63031953sanies_
sayest94217743sa_yest
scantest101710183scantest
sennet64224143senne_t
sennets73712583sennets
sonnet65923503sonne_t
sonnets74211993sonnets
soonest7415593soonest
stablest103312943stablest
stagiest91613403stagiest
staidest939803staidest
stalest73720173sta_lest
stances93715963stances_
stanchest14218213stanchest
stanes64933403sta_nes_
stanines85115663stanines_
starkest1239723starkest
sternest8314433sternest
stoniest8413543stoniest
strangest103210843strangest
sunniest82712903sunniest
swankest15105933swankest
tabes76033923ta_bes_
tables84524883tables_
tablet84227643table_t
tablets94714373tablets
taces76237803ta_ces_
tacet75840023ta_ce_t
taches114224173taches_
tachist12613293tachist
tacket124627493tacke_t
tackets134914363tackets
tackiest143112433tackiest
tains54936323tain_s_
taint55542283tain__t
taints64520533taints_
tajes124920693ta_jes_
takes94437793ta_kes_
talent6323323ta_lent
talents7312013talents
tales55451373ta_les_
talkiest123611223talkiest
tallness837103tallness
tameness102411253tameness
tames75242013ta_mes_
tandem9311403tande_m
tandems1037633tandems
tanged84622493tange_d
tangelo837033tangelo
tangents938713tangents
tanginess10239283tanginess
tangles83920043tangles_
tangliest1068423tangliest
tangos74216303tangos_
tangs65028343ta_ngs_
tanists7313653ta_nists
tankas104613763tankas_
tanked113919293tanke_d
tanker104521123tanke_r
tankers113416913tankers
tankless12267823tankless
tanks94624733ta_nks_
tannage8209583tannage
tannages9228963tannages_
tannate71813523tannate
tannates81911953tannates_
tannic82811473tann_ic
tannin62613923tann_in
tanning83618253tanning
tannins72813223tannins
tannoy958353tann_oy
tannoys1055553tannoys
tanrec837803tanre_c
tanrecs934823tanrecs
tans46154813ta_n_s_
tansies74521243tansies_
tansy84514933ta_n_sy
tapes75838603ta_pes_
tappet103820113tappe_t
tappets113610013tappets
tardiest93515243tardiest
tares57456563ta_res_
targes74524593targes_
target75028903targe_t
targets84314223targets
tarnish101611873tarnish
tarns56433953tarn_s_
tarres64723043tarres_
tarriest83215003tarriest
tartiest82718313tartiest
tartness82210133tartness
tasses64826763tasses_
tasset65925313tasse_t
tassets75012773tassets
tastes64126423tastes_
tastiest83216633tastiest
tates55444983ta_tes_
tattiest83415383tattiest
taunt55532283taun__t
taunts65715663taunts_
taupes8212673taupes_
tautness8217183tautness
tawney12338233tawne_y
tawneys13324773tawneys
tawnies102812503tawnies_
tawniness1245123tawniness
tawses94913193tawses_
taxes124730823ta_xes_
taxies135817333taxies_
taxless1436903taxless
teariest82417263teariest
teeniest82112413teeniest
telnet6518833telne_t
telnets738373telnets
tempest1139223tempest
tenet55542213t_ene_t
tenets65518953t_enets
tenner64117103tenne_r
tenners74014923tenners
tennies73017973tennies_
tennis64015303tennis_
tennists8297793tennists
tenses64722553tenses_
tentiest82115613tentiest
tenues63816443tenues_
ternes65422903ternes_
tersest71713993tersest
test48651623t___est
thanes94918983thanes_
thinness11277153thinness
tidiest83514873tidiest
tines54848423t_ines_
tinges74722323tinges_
tininess8310633tininess
tinned74317533tinne_d
tinner64119953tinne_r
tinners73717303tinners
tones56048663t_ones_
tonlet62924703tonle_t
tonlets73212503tonlets
tonne54921433tonne__
tonneau765913tonneau
tonner64819203tonne_r
tonners73816403tonners
tonnish10149093tonnish
trances93919643trances_
trannies8415013trannies_
transect10410053transect
transept1048633transept
trapnests1144433trapnests
trines64132563trines_
tritest7315273tritest
trones65629283trones_
truest64816193t_ruest
tunes55332193t_unes_
tunned74014493tunne_d
tunnel64310633tunne_l
tunnels7328723tunnels
tunnies73614263tunnies_
twangiest1355223twangiest
twines94717273twines_
twiniest1147153twiniest
twinset1039373twinset
tynes85920303t_ynes_
typiest1238203typiest
unrest62918853_unrest
vaguest1137333vaguest
vainness1136063vainness
vanes85130973va_nes_
vanned104614483vanne_d
vanner94215843vanne_r
vanners103612843vanners
vastest102911513vastest
viniest103216613viniest
wackest164710863wackest
waeness102512783waeness
wanes85040883wa_nes_
wanned104318013wanne_d
wanner94019623wanne_r
wariest105122503wariest
warmest123113033warmest
wattest102412153wattest
waviest134513073waviest
waxiest173510883waxiest
wenniest11259593wenniest
winiest103419693winiest
yarest95018913ya_rest
zanies153219673zanies_
zaniness1738663zaniness

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.1561145455.1
2DLD Change Limit1340274738.01616719.9
3Display Results4734730.1702782.4
 (SQL Overall)1786914738.34221420.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.