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

234 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
lagunas815682(None) 
lacunas9138171lacunas
laguna7127221laguna_
lagunes8148521lagunes
faunas94013632fa_unas
kahunas1473952kahunas
lacuna8118122lacuna_
lacunae9116802lacunae
lacunal9136552lacunal
lacunar9136292lacunar
lacunars10114732lacunars
lacunes9159622lacunes
lagans75717782lagan_s
lagends947272lagends
lagune7158632lagun_e
laminas93615872laminas
latinas74416462latinas
lauans65113532la_uans
lauras63414332la_uras
ligulas8329162ligulas
lunas55025012l__unas
naganas847982naganas
saunas63915432sa_unas
vaginas11298812vaginas
agamas97413443_agamas
agas55938843_ag__as
agendas936933_agendas
agenes74720253_agenes
agents74816293_agents
aghas97014873_ag_has
agings86312673_agings
agitas7310593_agitas
agmas85919873_ag_mas
agonal7410053_agonal
agones75719863_agones
agons66423783_agon_s
agoras7613343_agoras
agrias74315393_agrias
agues64919053_agu_es
ajugas1435263_ajugas
algas65624933alg__as
algins74816433algin_s
algums9208043algu_ms
anas46649863_a__nas
anginas8310953anginas
annas55824883_a_nnas
aquas142412613_aqu_as
arenas65021993_arenas
asanas6514113_asanas
aunts55227633_a_unts
auras55932553_a_uras
baguets1037483baguets
bananas93312223bananas
bunas75126573__bunas
cabanas112413033cabanas
cannas84518403ca_nnas
canulas9312853canulas
carinas93622383carinas
catenas9313103catenas
daggas937973dag_gas
dagobas1145143dagobas
daturas838763daturas
daunts75014083da_unts
faenas94412763fa_enas
fagins10513863fagin_s
farinas103215233farinas
fauna84816513fa_una_
faunae95210373fa_unae
faunal94711593fa_unal
fauns84516753fa_un_s
flagons1137973flagon_s
flaunts1056133fla_unts
flautas1036153fla_utas
galenas83310333galenas
guans64419443__guans
gunks104517723__gunks
guns55533483__gun_s
haunts95614393ha_unts
iguanas835373_iguanas
jacanas1638263jacanas
jagras1438463jag_ras
jaguar1435283jagu_ar
jaguars1535223jaguars
jarinas143712183jarinas
jaunts137511883ja_unts
kagus105812033kagu__s
kahuna1394103kahuna_
kanas95326913ka__nas
korunas1135443korunas
lacings105013653lacings
lacunary13114153lacunary
lacunate10128963lacunate
lacune8169673lacun_e
lacunose1083793lacunose
ladens74516233laden_s
ladings93814133ladings
ladinos8389963ladinos
lagan66520343lag__an
lagend838743lagen_d
lagers74826143lag_ers
laggers94216243laggers
laggings11298403laggings
lagoonal943093lagoonal
lagoons839253lagoons
lags56546223lag___s
lakings124713503lakings
lallans74113533lallans
lamas75532793la__mas
lambdas1246243lambdas
laments94314853laments
lamias85020613la_mias
lamina84920443lamina_
laminae93512973laminae
laminal94113633laminal
laminals10339303laminals
laminar93810283laminar
lampas106615953la_mpas
lanai5319573la__nai
lanais6316793la__nais
lands65426903la__nds
lanes54946793la__nes
langues81211913langu_es
languets987243languets
languors976153languors
langurs889103langu_rs
lantanas838263lantanas
lanugos834453lanugos
lapins84520683lapin_s
larums83610533laru_ms
larvas9310233la_rvas
lasagnas943673lasagnas
latens64620213laten_s
latents75214313latents
latina65621143latina_
latinos73613803latinos
latrias71913213latrias
lauan55216793la_u_an
lauds65618483la_u_ds
laughs10489023la_ughs
launce8469183la_unce
launces9329003la_unces
launch11368063la_unch
laura54116203la_ura_
laurae64011663la_urae
lavas85422223la__vas
lawines103313563lawines
lawings113611473lawings
lawns85215423la_wn_s
layins93817653layin_s
layups1133993layu_ps
lazulis1634903lazulis
leaguers935063leaguers
leagues837943leagu_es
legends936073legends
legongs934543legongs
legumes1036633legumes
lehuas935943lehu_as
lianas63713383l_ianas
ligands9438983ligands
ligans76817733ligan_s
lignan75510323lig_nan
lignans8398853lig_nans
ligula7359673ligula_
ligulae8308753ligulae
ligular8348533ligular
ligules82210913ligules
ligures8269883ligures
logans76319063logan_s
loggias9356783loggias
logins77820643login_s
logons79818173logon_s
loumas84812333l_oumas
lumas75622913l__umas
luna46229853l__una_
lunar57017313l__unar
lunars65012813l__unars
lunes55337773l__unes
lungs65223883l__ungs
lunks94822453l__unks
lunts55826903l__unts
maculas113114013maculas
magentas1137923magentas
magians10310753magians
magmas115512503mag_mas
magnums1234683magnums
magueys1333943magueys
magus85318753magu__s
malaguenas1352013malaguenas
mananas93414733mananas
manas76240423ma__nas
mannas85019803ma_nnas
marinas93519373marinas
maunds9519653ma_unds
mazumas2034623mazumas
mizunas1843693mizunas
nagana748943nagana_
nanas55928633na__nas
pagans95717923pagan_s
paginal10269493paginal
pagings114411063pagings
pagodas11367553pagodas
paruras9310533paruras
patinas96318523patinas
plaguers11286503plaguers
plagues103311063plagu_es
platinas103610313platinas
punas74826753__punas
radulas839583radulas
ragas65326063rag__as
raglans82410133raglans
ramonas9311093ramonas
ranulas7311773ranulas
reginas85614063reginas
saganash1243063saganash
sagas66025883sag__as
salinas73116093salinas
sauna54117553sa_una_
tabuns8489223tabun_s
talukas11316213talukas
taunts65715663ta_unts
teguas768013tegu_as
tunas54224123__tunas
vagina102710933vagina_
vaginae11377683vaginae
vaginal11288403vaginal
vagus96713813vagu__s
valutas1036533valutas
varnas94212823va_rnas
vaunts95212623va_unts
vicunas1285613vicunas
wagons103911213wagon_s
wanguns1135023wangun_s
yamuns11336513yamun_s
zananas16319563zananas

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.1561145455.1
2DLD Change Limit1340272347.03319056.9
3Display Results2342340.0763078.9
 (SQL Overall)1786912347.26524596.1
 
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.