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

189 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
tannages922896(None) 
tankages13217111tankages
tannage8209581tannage_
tannates81911951tannates
tonnages9187871tonnages
tunnages9195901tunnages
anlages82414112_anlages
annates72415422_annates
bandages12310632bandages
carnages11312212carnages
dunnages10154932dunnages
innages82911302_innages
manages103418962ma_nages
pawnages1435312pawnages
tallages92312002tallages
tanager83010942ta_nager
tanagers9259002ta_nagers
tankage12257772tankage_
tannate71813522tannate_
tentages91011042tentages
thanages12107622thanages
thenages12107482thenages
tonnage8168052tonnage_
tunnage8166372tunnage_
vantages12119022vantages
wannabes1344472wannabes
wantages12109022wantages
adages8412953_a_dages
agnates82813193_agnates
ambages1269623_ambages
anankes1138763_anankes
anlaces92313733_anlaces
anlage72514233_anlage_
anlagen8238643_anlagen
anlases72514903_anlases
annals66415923_anna_ls
annas55824883_anna__s
annexes1437203_annexes
apanages1137013apanages
badinages13124873badinages
baggages1335443baggages
bandage11311023bandage_
bandaged1337313bandaged
bandager1237703bandager
bandagers1335883bandagers
banjaxes2443393banjaxes
baronages1247153baronages
barrages11711083barrages
bondages1237893bondages
cabbages1537203cabbages
canapes111213083ca_napes
cannabis1266033cannabis
cannas84518403canna__s
canvases13349513canvases
carnage10311743carnage_
cartages11313313cartages
chantages1546583chantages
coinages11310803coinages
crannoges1244243crannoges
damages11511273da_mages
drainages1145503drainages
dunnage9175213dunnage_
encages103313783_encages
engages92912493_engages
enrages83114853_enrages
fanfares1436773fanfares
fannies103415643fann_ies
garages9314113ga_rages
garbages1238183garbages
gavages1237683ga_vages
handaxes1938403handaxes
haulages1236623haulages
haylages1536013haylages
incages103013883_incages
innage73011573_innage_
langrages11105903langrages
languages11115053languages
lavages1138603la_vages
linages8813173_linages
lineages979183lineages
linkages1385953linkages
maenades1137473maenades
magnates11511613magnates
manage93818903ma_nage_
managed113212603ma_naged
manager103413583ma_nager
managers112911003ma_nagers
mandates11314093mandates
maneges103612143ma_neges
manges94628943ma_n_ges
mannans93611523manna_ns
mannas85019803manna__s
mannites10312613mannites
mannoses1039083mannoses
massages1159883massages
menages103615393_menages
mintages111110513mintages
montages111412183montages
nannies73015203nann_ies
nonages8313843_nonages
packages17138733packages
padnags1135083padnag_s
pancakes1637073pancakes
pannes85522853pann__es
passages1139513passages
pawnage1335873pawnage_
pennames12287793pennames
peonages1138473peonages
pinnaces12268863pinnaces
rampages1336673rampages
ranges73826923ra_n_ges
ravages1139403ra_vages
rennases848983rennases
salvages1238123salvages
sausages937003sausages
savages1139973sa_vages
signages1037483signages
sinkages1386853sinkages
spinages11289293spinages
stagnates1046733stagnates
stannaries1045773stannaries
stannites947023stannites
tacnodes1145003tacnodes
taeniases944333taeniases
tagrags936123tagrag_s
takahes1436173ta_kahes
tallage82712073tallage_
tallaged10257923tallaged
tamales93216153ta_males
tanbarks1445563tanbarks
tanged84622493ta_n_ged
tangles83920043ta_ngles
tangos74216303ta_n_gos
tangs65028343ta_n_g_s
tankards1366253tankards
tankas104613763tanka__s
tannable1039383tannable
tanned75219953tann__ed
tanner63722283tann__er
tanneries9310423tanneries
tanners74018393tann_ers
tannest72617853tann__est
tannings9268633tannings
tannins72813223tann_ins
tannoys1055553tann_oys
tansies74521243ta_nsies
tantalus836373tantalus
tantaras8269543tantaras
tanyards1276183tanyards
tapenades1245063tapenades
targes74524593ta__rges
tawnies102812503tawn_ies
teenage8108053teenage_
teenaged10105133teenaged
teenager9115293teenager
teenagers10114493teenagers
tenaces92814513t_enaces
teniases838623teniases
tennies73017973tenn_ies
tennises82810133tennises
tentage81010643tentage_
thanage11117943thanage_
thenage11107843thenage_
tillages93011263tillages
tinges74722333t_in_ges
tinwares1137913tinwares
tollages92410193tollages
tonnes65320853tonn__es
towages1139233t_owages
trackages1645343trackages
trannies8415013trann_ies
triages82613793t_riages
tunnies73614263tunn_ies
twinges11409453twin_ges
uncages103213773_uncages
vantage11109893vantage_
ventages12119773ventages
vintages12118273vintages
waftages15105393waftages
wagonages1443303wagonages
wannabe1234533wannabe_
wannabee1343993wannabee
wannabees1442213wannabees
wantage11119623wantage_
warpages1437053warpages
wastages12109753wastages
wattages12106783wattages
windages1338263windages
yardages1336203yardages

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.403443402.0
2DLD Change Limit1461621897.16020413.7
3Display Results1891890.0762486.8
 (SQL Overall)1786911897.63923391.9
 
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.