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

252 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
labium1041024(None) 
labrum1057421labrum
album92312652alb_um
allium8311242allium
barium10313512barium
cambium1537322cambium
erbium1038082erbium
kalium1239472kalium
labarum1166012labarum
labia75219012labi_a
labial84714342labial
labile8315222labile
labour84210932labour
labrums1175852labrums
larum74317972la_rum
pablum1237502pablum
radium93513292radium
abeam9316533_abeam
abide86223713_abide
abohm1247973_abohm
about75229083_about
abut66834953_ab_ut
abysm12598143_abysm
aecium10410423aecium
agism84614063_agism
aim57858213_a_i_m
alarum85411983alarum
albino839933albino
albite8313313albite
albums10198273alb_ums
algum82711763_algum
alliums957973alliums
alodium1047583alodium
alum65227613_a_lum
arum66129033_a_rum
atrium8411823atrium
aurum7614963_aurum
axiom143913593_axiom
babied114913513babied
babier103515573babier
babies106123653babies
babu85829233bab_u_
babul96317713bab_ul
babus95620333bab_us
bariums1139143bariums
bum75342693__b_um
cabin94820943cabi_n
cabins104418923cabins
cadmium1446113cadmium
caecum1238183caecum
caesium1158833caesium
caladium1347023caladium
calcium1368593calcium
cambism1538033cambism
cambiums1644933cambiums
cerium10313763cerium
cesium1039583cesium
cilium104311373cilium
cladism1238553cladism
claim95616913cla_i_m
conium10415313conium
corium10315723corium
cranium11911103cranium
cubism12348703cubism
curium10312503curium
dadgum1134583dadgum
datum8310633da_tum
dubnium1244183dubnium
eluvium1244973eluvium
erbiums1135463erbiums
fanum10313443fa_num
favism1437913favism
folium11310453folium
gabies93820733gabies
gabion93211033gabion
gallium1037943gallium
gaum75726423ga__um
gonium949803gonium
habile11515213habile
habit103027023habi_t
habits113014653habits
habitue12266703habitue
habitus12338173habitus
habu97325483hab_u_
habus106317143hab_us
hafnium1544243hafnium
hahnium1544433hahnium
hakim14311833haki_m
hassium1236133hassium
helium112311253helium
ilium74614183_ilium
indium939503indium
ionium8610923ionium
jabiru15125513jabiru
jabirus1694573jabirus
kabiki1134783kabiki
kaliums1336603kaliums
lab58864783lab___
labara83712893labara
labarums1254503labarums
labdanum1342923labdanum
label75019383lab_el
labellum1274273labellum
labels84515683labels
labials9299873labials
labiate91313573labiate
labor75117313lab_or
labors84016413labors
labours9349893labours
labra75415463lab_ra
labret8320223labret
labs67145123lab__s
laburnum1262913laburnum
lacier84020093lacier
lacily11612763lacily
lacing94626233lacing
lactam10310943lactam
ladanum1045183ladanum
ladies75124883ladies
lading84227123lading
ladino73615123ladino
laic65931563la_i_c
laich105920713la_ich
laicism1138243laicism
laics76419253la_ics
laid56439143la_i_d
laigh95515923la_igh
lain46146283la_i_n
lair45934153la_i_r
laird65417793la_ird
lairs55425873la_irs
laith85722103la_ith
laity85318903la_ity
lakier104716273lakier
laking115027043laking
lalique1644423lalique
lam57666713la___m
lambie103213673lambi_e
lambier113611643lambier
lambies113015113lambies
lambing123412413lambing
lamia75324323lami_a
lamiae84817453lamiae
lamias85020613lamias
lamina84920443lamina
laming94528363laming
langue71012183langue
langur7109313langur
lapful1156483lapful
lapin75222923lapi_n
lapins84520683lapins
lapis76223153lapi_s
lapsus8437273lapsus
lari45839153lari__
lariat6629043lariat
larine63927043larine
laris54737463lari_s
larrup835713larrup
larums83610533la_rums
lasing74727983lasing
lati46438273lati__
latigo73410013latigo
latina65621143latina
latino64120473latino
latish92416173latish
latu47934183la_tu_
laud56527723la__ud
laving104623573laving
lavish124112983lavish
lawful1235493lawful
lawine93316463lawine
lawing104625283lawing
laxity1637273laxity
layin84720333layi_n
laying104525703laying
layins93817653layins
layout9513703layout
layup1037723la_yup
lazied164610653lazied
lazier154214613lazier
lazies154418783lazies
lazily1859713lazily
lazing164821473lazing
libido935753libido
linum7313823l_inum
lithium1245823lithium
locum94812173l_ocum
lubing94114043lubing
lum55542933l___um
luteum837783luteum
lyceum1343953lyceum
lyrism1137473lyrism
magnum1136733magnum
maim85831493ma_i_m
maxim165216003maxi_m
maximum1743573maximum
medium113711623medium
milium104712683milium
minium106014423minium
nabis76020583nabi_s
nanism8311203nanism
natrium948983natrium
niobium1144723niobium
oakum1177313oa_kum
odium83413033_odium
oidium959813oidium
onium73115533_onium
opium92812093_opium
osmium1036573osmium
ostium8310133ostium
pablums1345123pablums
pabulum1344473pabulum
pallium1149013pallium
panicum1346393panicum
papism122211513papism
platinum1245443platinum
podium112911913podium
rabic93817403rabi_c
rabid84520783rabi_d
rabies85226023rabies
racism103214193racism
radiums10299313radiums
radius73914873radius
sabin74924953sabi_n
sabine84020393sabine
sabins85521983sabins
sabir75917003sabi_r
sabirs85414633sabirs
sacrum103910143sacrum
sadism94113493sadism
sagum8512873sa_gum
sebum93814553seb_um
sodium92111453sodium
solarium1078263solarium
solatium1067613solatium
stadium1038073stadium
stibium1145843stibium
subgum1136133subgum
tabid84418263tabi_d
tabour84011323tabour
tabu66328493tab_u_
tabun75914373tab_un
tabus74820923tab_us
talcum1036953talcum
tedium9269873tedium
telium82611393telium
terbium1147293terbium
uranium9610023uranium
vacuum1334833vacuum
velarium1347073velarium
wampum15406053wampum
zoarium1846093zoarium

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162525.12621989.1
3Display Results2522520.0763315.8
 (SQL Overall)1786912525.59231954.8
 
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.