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

162 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
lactean95647(None) 
lacteal966811lacteal
lactam10310942lact_am
lacteals1095662lacteals
lantern7310012lantern
lateen64014862la_teen
laten54328342la_te_n
latten65018202latte_n
lectern937032lectern
aceta74017353_aceta_
acetal84314903_acetal
acetin8314693_acetin
acta69524803_act_a_
acted88521733_acte_d
actin74922553_act_in
action84719683_action
actual8311023_actual
archean1269123archean
astern64815813_astern
atman75520143_a_tman
bacterin12410273bacterin
bateau8810563ba_teau
batman105214063ba_tman
batteau936343batteau
batten85217123batte_n
blacken15439793blacke_n
bracteal1245563bracteal
caftan111710123caft_an
canteen9411083canteen
captan101613343capt_an
catena8312483ca_tena
cateran9313773ca_teran
clachan1437183clac_han
clean75420413__clean
eastern74412533eastern
eaten55323053ea_te_n
faction122613333faction
factual1246723factual
fasten95114893faste_n
fatten94314903fatte_n
flatten10429653flatte_n
gateau778113ga_teau
gateman1057473ga_teman
hackman1836433hackman
hapten115312983hapte_n
hasten95718563haste_n
kaftan13185823kaft_an
lace66848473lac_e__
laced87132643lac_e_d
lacer75833753lac_e_r
lacers85225253lac_ers
laces76141763lac_e_s
lacey105820913lac_e_y
laches116528343lache_s
lacier84020093lacie_r
laciest93819033laciest
lacked135324653lacke_d
lacker125325623lacke_r
lackers134120543lackers
lackey154813353lacke_y
lackeys16458263lackeys
lactams1136953lactams
lactary1237843lactary
lactase937953lactase
lactate9312693lactate
lacteally1444473lacteally
lacteous1046773lacteous
lactic10713493lact_ic
lactone9311403lactone
lactose969483lactose
lacuna8118123lacuna_
lacunae9116803lacunae
lacunal9136553lacunal
lacunar9136293lacunar
lacunas9138173lacunas
laden65022193la_de_n
lagan66520343la__gan
lallan63414173la_llan
landman1038923landman
lantana739603lant_ana
lanterns838303lanterns
larchen12479623larche_n
lasted74323603laste_d
laster64830633laste_r
lasters75627693lasters
late47560483la_te__
lated65240673la_te_d
lateens74210553la_teens
lately93413843la_tely
latens64620213la_tens
latent64124303la_tent
later54843923la_te_r
laterad8310843la_terad
lateral7313573la_teral
latest63822703la_test
latex124717113la_te_x
latina65621143la_tina
latte55426303latte__
lattens75014673lattens
latter65027893latte_r
lattes65324203latte_s
lattin64316223la_ttin
lauan55216793la__uan
lawman11289053la_wman
lawmen11308593lawme_n
layman113511303la_yman
laymen113010843layme_n
lean46345243l___ean
lecterns1035943lecterns
lectin82515013lect_in
lection92614863lection
lenten6312883lente_n
lethean1037093lethean
lichen114012743liche_n
liftman1244063liftman
listen64816813liste_n
litten64014873litte_n
lochan1139093loc_han
lucern846103luc_ern
lutea54819073l_utea_
luteal64411483l_uteal
lutein6311263l_utein
lycea10418943lyc_ea_
lyncean1292923lyncean
manteau937863manteau
marten84518263marte_n
martian93514683martian
oaten55222403oa_te_n
ocean71212963_oc_ean
octan71313483_oct_an
packman1736693packman
paction112713963paction
paean77222723pa__ean
pampean1335543pampean
partan83820563part_an
pastern94415063pastern
paten74827343pa_te_n
patten84418193patte_n
pattern93712053pattern
pecten102711103pecte_n
placeman1445683placeman
platan83913693pla_t_an
plateau937403pla_teau
platen84518203pla_te_n
protean92412193protean
ratan53722663ra_t_an
rattan63613603ra_ttan
ratteen7329113ratteen
ratten64217383ratte_n
reclean938523reclean
saltern74010653saltern
saltpan935303saltpan
sateen63815013sa_teen
slacken13399933slacke_n
slattern837093slattern
taction93213023taction
tactual936203tactual
tartan64217513tart_an
tauten64311893taute_n
unclean946973unclean
xanthan1736013xanthan
yachtman1842653yachtman

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.403443402.0
2DLD Change Limit1340271626.78319759.3
3Display Results1621620.0463521.7
 (SQL Overall)1786911627.23224708.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.