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

145 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
lantanas83826(None) 
lantana739601lantana_
bananas93312222ban_anas
bandanas11178572bandanas
cantalas104013522cantalas
cantatas103410092cantatas
cantinas102713782cantinas
latinas74416462la_tinas
mananas93414732man_anas
tantaras8269542tantaras
tartanas8258892tartanas
zananas16319562zan_anas
anabas8314083_an_abas
anginas8310953_anginas
annas55824883_an__nas
annonas738793_annonas
antas55432033_ant__as
antennas846403_antennas
antings85015583_antings
asanas6514113_a_sanas
banana83213413ban_ana_
bandana10179463bandana_
bandannas12163283bandannas
banians9312033banian_s
bantams1149063banta_ms
bantengs1134593bantengs
banyans1237913banyan_s
cabanas112413033ca_banas
caftans12179443caftan_s
cancans11311873cancan_s
cannas84518403can__nas
cantala94114673cantala_
cantals93919573canta_ls
cantata93811813cantata_
cantina93417253cantina_
cantonal1038903cantonal
cantons95221203canton_s
canzonas1935383canzonas
captans111612053captan_s
catenas9313113ca_tenas
damianas1155573damianas
fantails1139693fantails
fantasias1286993fantasias
fantasms1345633fantasms
fantasts1147113fantasts
fontinas1136853fontinas
haftaras14136073haftaras
harianas1139163harianas
jacanas1638263ja_canas
jnanas13207303_jn_anas
kaftans14185353kaftan_s
kanakas10327213kan_akas
kanbans1337723kanban_s
kantars11310033kanta_rs
lactams1136953lacta_ms
lactases1038523lactases
lactates10311233lactates
lactones10311243lactones
lacunas9138173la_cunas
lagans75717783la_gan_s
lagunas8156823la_gunas
laitance1045973laitance
laitances1145613laitances
lallands9338573lallands
lallans74113533lallan_s
lambadas1354873lambadas
laminas93615873la_minas
lanais6316793lan_a_is
landaus8310343landa_us
landings103110073landings
laniards967313laniards
lanitals837723lanita_ls
lanterns838303lanterns
lanthanon1252623lanthanon
lanthanons1352553lanthanons
lanthanum1452533lanthanum
lanthanums1551853lanthanums
lanyards1266393lanyards
lasagnas943673lasagnas
lastings94214423lastings
latakias1245583la_takias
latens64620213la_ten_s
latents75214313la_tents
latina65621143la_tina_
latinos73613803la_tinos
latrias71913213la_trias
lattens75014673latten_s
lattins74115483lattin_s
lauans65113533la_uan_s
lentando943603lentando
lianas63713383l__ianas
lindanes939173lindanes
linsangs944413linsangs
longans84510813longan_s
lungans8399053lungan_s
manana84816073man_ana_
mandalas1139443mandalas
mannans93611523mannan_s
mannas85019803man__nas
mantas85725363mant__as
mantras93815863mant_ras
mantuas93410993mant_uas
mastabas1246803mastabas
montanes101114523montanes
naganas847983na_ganas
nanas55928633__n_anas
nandinas936583nandinas
paisanas10288873paisanas
panadas103312213pan_adas
panamas113112763pan_amas
pandanus1136433pandanus
partans94418283partan_s
pastinas103712153pastinas
patacas11311003pa_tacas
patinas96318523pa_tinas
pentanes10316083pentanes
pintadas11105083pintadas
pintanos10107553pintanos
plantains1147493plantains
plantings12348403plantings
platanes102711883pla_tanes
platans93413123pla_tan_s
platinas103610313pla_tinas
randans8313213randan_s
ratans63819373ra_tan_s
rattans73411953rattan_s
santeras8311063santeras
sardanas937823sardanas
satangs8479713sa_tangs
sataras7315063sa_taras
sultanas8237153sultanas
suntans72111733suntan_s
tantalus836373tantalus
tantara72410823tantara_
tantras73112093tant_ras
tartana73010193tartana_
tartans72615823tartan_s
vantages12119023vantages
wangans1149503wangan_s
wantages12109023wantages
wantons103713013wanton_s
xanthans1845693xanthan_s
yantras10259003yant_ras
zanana153810363zan_ana_
zenanas16286233zen_anas

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.406440125.6
2DLD Change Limit1461621457.20320291.8
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.67223291.3
 
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.