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

228 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
tannates8191195(None) 
annates72415421_annates
tannages9228961tannages
tannate71813521tannate_
agnates82813192_agnates
magnates11511612magnates
mandates11314092mandates
mannites10312612mannites
stagnates1046732stagnates
stannites947022stannites
tankages13217112tankages
tannage8209582tannage_
tonnages9187872tonnages
tunnages9195902tunnages
wannabes1344472wannabes
abates85825033_a_bates
ablates92416903_ablates
adnate72913483_adnate_
aerates74627493_aerates
agates76121343_a_gates
agnate73314883_agnate_
alates64833973_a_lates
anankes1138763_anankes
andantes9310853_andantes
animates101316423_animates
anlaces92313733_anlaces
anlages82414113_anlages
anlases72514903_anlases
annals66415923_anna_ls
annas55824883_anna__s
annatto7144153_annatto
annattos8133723_annattos
annexes1437203_annexes
annotates977293_annotates
ansate64517863_ansate_
ansated84214003_ansated
antes56334323_a_n_tes
atlantes838553atlantes
aviates10313063_aviates
bandages12310633bandages
bandmates1447923bandmates
banjaxes2443393banjaxes
banknotes1544313banknotes
bannets94013843bannet_s
canapes111213083ca_napes
cannabis1266033cannabis
cannas84518403canna__s
cannulates1247783cannulates
cantatas103410093cantatas
canulates11312873canulates
canvases13349523canvases
carates95630613ca_rates
carnages11312213carnages
caseates10313713caseates
catenates11311813catenates
caudates11310263caudates
cognates11311583cognates
connate9315753connate_
connotes10311453connotes
craniates11310653craniates
cyanates13238433cyanates
donates83217223_donates
dunnages10154933dunnages
dunnites947173dunnites
emanates10311333emanates
enates64026433__enates
fanfares1436773fanfares
fannies103415643fann_ies
gahnites1235703gahnites
gallates92815533gallates
gannets83811443gannet_s
hamates122917683ha_mates
handaxes1938403handaxes
ingates82716913_ingates
inmates92715783_inmates
innages82911303_innages
innate63917313_innate_
kainites1238793kainites
karates115617473ka_rates
khanates1535733khanates
labiates101011513labiates
lactates10311233lactates
laminates112712903laminates
lanate6421263la_nate_
lanated8313203la_nated
lancinates1247153lancinates
maenades1137473maenades
magnate10512703magnate_
malates93522613ma_lates
maleates103316343maleates
manages103418963ma_nages
manatee9317663ma_natee
manatees10310423ma_natees
manats84623463ma_nat_s
mandate10315573mandate_
mandated12310293mandated
manganates1345953manganates
mannans93611523manna_ns
mannas85019803manna__s
mannite9312903mannite_
mannoses1039083mannoses
mantes84430783ma_n_tes
marinates112516383marinates
nannies73015203nann_ies
narrates8312763narrates
nates55238333___nates
neonates8310063neonates
odonates947743odonates
ozonates1745963ozonates
paginates123111363paginates
palates93624943pa_lates
palpates122613063palpates
pancakes1637073pancakes
pannes85522853pann__es
patinates113814693patinates
pawnages1435313pawnages
penates93321603_penates
pennames12287793pennames
pennate93314033pennate_
pennated11299543pennated
phenates13611583phenates
phonates13410643phonates
pinnaces12268863pinnaces
pinnate93613743pinnate_
pinnated11338553pinnated
pronates10418373pronates
qanats154112813qa_nat_s
radiates92415293radiates
rennases848983rennases
ruinates8311883ruinates
sanitates9611733sanitates
satiates8314633satiates
savates10312953sa_vates
senates73322613_senates
sensates8511143sensates
sinuates8310963sinuates
stagnate947243stagnate_
stagnated1145143stagnated
stannaries1045783stannaries
stannite847583stannite_
tabulates1139143tabulates
tacnodes1145003tacnodes
taconites1148473taconites
taeniases944333taeniases
tailgates1046533tailgates
tainted83512423tain_ted
taints64520533tain_t_s
takahes1436173ta_kahes
tallages92312003tallages
tamales93216153ta_males
tanager83010943ta_nager
tanagers9259003ta_nagers
tanbarks1445563tanbarks
tangles83920043ta_ngles
tanists7313653tanist_s
tankage12257773tankage_
tankards1366253tankards
tankas104613763tanka__s
tannable1039383tannable
tanned75219953tann__ed
tanner63722283tann__er
tanneries9310423tanneries
tanners74018393tann_ers
tannest72617853tann__est
tannings9268633tannings
tannins72813223tann_ins
tannoys1055553tann_oys
tansies74521243ta_nsies
tantalates10106703tantalates
tantalites1099283tantalites
tantalus836373tantalus
tantaras8269543tantaras
tanyards1276183tanyards
tanzanites1944003tanzanites
tapenades1245063tapenades
tarantas839193tarantas
tartrates979563tartrates
tastes64126423ta__stes
tates55444983t___ates
taunted84310963taun_ted
taunter73111453taun_ter
taunters8259273taun_ters
taunts65715663taun_t_s
tawnies102812503tawn_ies
taxites1449673ta_xites
teammates1345673teammates
tenaces92814513t_enaces
tenanted937043tenanted
tenants7311013tenant_s
teniases838623teniases
tennies73017973tenn_ies
tennises82810133tennises
tentages91011043tentages
ternate7415483ternate_
testates83615453testates
thanages12107623thanages
thanatos1165123thanatos
thenages12107483thenages
thionates12106663thionates
tinnitus843783tinnitus
tinplates1147773tinplates
tinwares1137913tinwares
titanates976093titanates
titrates82314663titrates
toluates8138903toluates
tonettes839203tonettes
tonnage8168053tonnage_
tonnes65320853tonn__es
tractates1159763tractates
trannies8415013trann_ies
translates10411703translates
truncates1145843truncates
tunicates11268743tunicates
tunnage8166373tunnage_
tunnies73614263tunn_ies
urinates8314133urinates
vacates12312833va_cates
valuates112811203valuates
vanadates1345133vanadates
vantages12119023vantages
variates111214983variates
venenates1247583venenates
wannabe1234533wannabe_
wannabee1343993wannabee
wannabees1442213wannabees
wantages12109023wantages
xanthates1945653xanthates
zincates1937743zincates

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622287.34319904.9
3Display Results2282280.1102072.7
 (SQL Overall)1786912287.88922650.7
 
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.