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

208 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
lantana73960(None) 
lantanas838261lantanas
banana83213412ban_ana
bandana10179462bandana
cantala94114672cantala
cantata93811812cantata
cantina93417252cantina
latina65621142la_tina
manana84816072man_ana
tantara72410822tantara
tartana73010192tartana
zanana153810362zan_ana
angina7413133_angina
anna45529013_an__na
annona648873_annona
anta46839583_ant__a
antae56828293_anta_e
antas55432033_anta_s
antenna746383_antenna
anting75827023_anting
antra56521923_ant_ra
arcana8912583_arcana
asana5315483_a_sana
bananas93312223ban_anas
bandanas11178573bandanas
bandanna11174073bandanna
banian8315383banian_
banians9312033banians
bantam10314063banta_m
bantams1149063bantams
banteng1046363banteng
banyan1139483banyan_
banyans1237913banyans
blatant9310673bla_tant
cabana103913563ca_bana
caftan111710123caftan_
caftans12179443caftans
cancan10314103cancan_
cancans11311873cancans
canna75919333can__na
cantal84122033canta_l
cantalas104013523cantalas
cantals93919573cantals
cantatas103410093cantatas
cantinas102713773cantinas
canting104725903canting
canton85722993canton_
cantonal1038903cantonal
cantons95221203cantons
canzona1836073canzona
captan101613343captan_
captans111612053captans
catena8312483ca_tena
damiana1046563damiana
fantail10310233fantail
fantasia1197013fantasia
fantasm1236593fantasm
fantast10311703fantast
fantasy1336153fantasy
fontina1038633fontina
haftara13136093haftara
hanting114124483hanting
hariana10310243hariana
jacana1537933ja_cana
jnana12159043_jn_ana
kaftan13185823kaftan_
kaftans14185353kaftans
kanaka9357523kan_aka
kanban1238623kanban_
kanbans1337723kanbans
kantar10311153kanta_r
kantars11310033kantars
labara83712893la_bara
lactam10310943lacta_m
lactams1136953lactams
lactary1237843lactary
lactase937953lactase
lactate9312693lactate
lactean956473lactean_
lactone9311393lactone
lacuna8118123la_cuna
lagan66520343la_gan_
lagans75717783la_gans
laguna7127223la_guna
laitance1045973laitance
lallan63414173lallan_
lalland83810183lalland
lallans74113533lallans
lambada1245643lambada
lamina84920443la_mina
lanai5319573lan_a_i
lanais6316793lan_ais
lanate6421263lan_ate
lanated8313203lanated
lancing103314123lancing
landau7310613landa_u
landaus8310343landaus
landing92819323landing
landman1038923landman_
laniard868523laniard
laniary1068013laniary
lanital7310913lanita_l
lanitals837723lanitals
lantern7310013lantern
lanterns838303lanterns
lanthanon1252623lanthanon
lanthanum1452533lanthanum
lanyard1167293lanyard
lasagna843543lasagna
lasting84725243lasting
latakia1146093la_takia
laten54328343la_ten_
latens64620213la_tens
latent64124303la_tent
latinas74416463la_tinas
latino64120473la_tino
latria62313593la_tria
latten65018203latten_
lattens75014673lattens
lattin64316223lattin_
lattins74115483lattins
lauan55216793la_uan_
lauans65113533la_uans
lawman11289053lawman_
layman113511303layman_
lentando943603lentando
lenten6312883lenten_
liana53915893l__iana
lindane839033lindane
linsang835863linsang
linting83820983linting
litany939053l_itany
longan75612363longan_
longans84510813longans
lungan74710213lungan_
lungans8399053lungans
lunting83817743lunting
mananas93414733man_anas
mandala10310213mandala
manna75522543man__na
mannan85413623mannan_
mannans93611523mannans
manta75629913mant__a
mantas85725363manta_s
mantra84116093mant_ra
mantua84412023mant_ua
mastaba1146223mastaba
montane91313623montane
nagana748943na_gana
nana46632903__n_ana
nandina838913nandina
natant6318733na_tant
paisana94010223paisana
panada94113053pan_ada
panama104213353pan_ama
pandani1039903pandani
panting104025423panting
partan83820563partan_
partans94418283partans
pastina93914593pastina
pataca10311193pa_taca
patina86022193pa_tina
pentane9415743pentane
pintada1096083pintada
pintano998993pintano
plantain1047903plantain
plantains1147493plantains
plantar9369993planta_r
planting113515383planting
platan83913693pla_tan_
platane93112303pla_tane
platans93413123pla_tans
platina94413643pla_tina
randan7315253randan_
randans8313213randans
ranting84025413ranting
ratan53722663ra_tan_
ratans63819373ra_tans
ratany93411873ra_tany
rattan63613603rattan_
rattans73411953rattans
saltant7316773saltant
santera7311303santera
sardana838643sardana
satang75711563sa_tang
satara6315533sa_tara
slanting94115093slanting
sultana7257803sultana
suntan62613003suntan_
suntans72111733suntans
tantaras8269543tantaras
tantra63713353tant_ra
tartan64217513tartan_
tartanas8258893tartanas
tartans72615823tartans
vanman1139793vanman_
vantage11109893vantage
wangan10311223wangan_
wangans1149503wangans
wantage11119623wantage
wanting114220173wanting
wanton94413813wanton_
wantons103713013wantons
xanthan1736013xanthan_
xanthans1845693xanthans
yantra9449623yant_ra
zananas16319563zan_anas
zenana15297983zen_ana

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 Filter1786911340270.423422437.4
2DLD Change Limit1340272086.89019452.4
3Display Results2082080.0762736.8
 (SQL Overall)1786912087.38924183.4
 
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.