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

149 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
lacteal96682(None) 
lacteals1095661lacteals
lactean956481lactean
acetal84314902_acetal
actual8311022_actual
bracteal1245562bracteal
factual1246722factual
lactam10310942lact_am
lacteally1444472lacteally
lacunal9136552lacunal
lateral7313572la_teral
luteal64411482l_uteal
tactual936202tactual
aceta74017353_aceta_
acetals93411353_acetals
acetyl11396553_acetyl
acta69524803_act_a_
acted88521733_acte_d
actinal9312293_actinal
allheal1044553allheal
anneal64812293_anneal
antral65719413_antral
apneal83411123_apneal
appeal103911613_appeal
apteral9311523_apteral
areal55928733_a_real
artal55525473_art_al
artel56122743_arte_l
astral66919283_astral
bacterial1348363bacterial
balneal936573balneal
bateau8810563ba_teau
batteau936343batteau
blastemal1343783blastemal
cantal84122033cant_al
canthal12410053canthal
cartel85022533carte_l
dactyl1234983dact_yl
ductal938993duct_al
facial113615633fac_ial
factful1536373factful
fatal84819373fa_t_al
fractal1237623fract_al
gametal1037603gametal
gastral8329553gastral
gateau778113ga_teau
glacial1038143glac_ial
gluteal854243gluteal
hartal9415473hart_al
jacal14313703jac__al
jackal1937613jac_kal
label75019383la_be_l
labial84714343la_bial
lace66848473lac_e__
laced87132643lac_e_d
lacer75833753lac_e_r
lacers85225253lac_ers
laces76141763lac_e_s
lacey105820913lac_e_y
laches116528353lache_s
lacier84020093lacie_r
laciest93819043laciest
lacked135324653lacke_d
lacker125325623lacke_r
lackers134120543lackers
lackey154813353lacke_y
lackeys16458263lackeys
lacrimal1244443lacrimal
lactams1136953lactams
lactary1237853lactary
lactase937963lactase
lactate9312703lactate
lacteous1046773lacteous
lactic10713493lact_ic
lactone9311413lactone
lactose969493lactose
lacuna8118123lacuna_
lacunae9116803lacunae
lacunar9136293lacunar
lacunas9138173lacunas
laical8312323la_ical
laminal94113633laminal
lanital7310913lanital
lantern7310013lantern
lapel73716683la_pe_l
larval948503la_rval
lasted74323603laste_d
laster64830633laste_r
lasters75627693lasters
late47560483la_te__
lated65240673la_te_d
lateen64014863la_teen
lately93413843la_tely
laten54328343la_te_n
latens64620213la_tens
latent64124303la_tent
later54843923la_te_r
laterad8310843la_terad
laterals8312753la_terals
latest63822703la_test
latex124717113la_te_x
latte55426303latte__
latten65018203latte_n
lattens75014673lattens
latter65027893latte_r
latterly1136063latterly
lattes65324203latte_s
laurel649033laure_l
leal46043273l___eal
lectern937033lectern
lethal939803l_ethal
lineal65616023l_ineal
lintel64013993linte_l
listel64214743liste_l
literal7613273l_iteral
local74820273loc__al
lochial1257083lochial
loreal63814313l_oreal
lustral7339653lustral
lutea54819073l_utea_
lycea10418943lyc_ea_
manteau937863manteau
mantel84317973mante_l
martial92415413martial
natal53921493na_t_al
nucleal946693nucleal
oatmeal944973oatmeal
octal71214723_oct_al
osteal6312963_osteal
paleal84716673pa_leal
partial92616263partial
pastel85918713paste_l
plastral1046913plastral
plateau937403pla_teau
rachial122012173rachial
racial83419243rac_ial
ratal55025113ra_t_al
ratel54224883ra_te_l
rectal84418133rect_al
rictal83113183rict_al
sacral83414413sac_ral
steal56125473__steal
tactful1236163tactful
tactical1248843tactical
tapetal938273tapetal
teal45546503___teal
tectal83713253tect_al
tracheal1348253tracheal
victual1246253victual

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.406440125.6
2DLD Change Limit1340271496.53020524.8
3Display Results1491490.0463239.1
 (SQL Overall)1786911496.98225593.1
 
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.