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
labium1041023(None) 
labrum1057421labrum
album92312652alb_um
allium8311242allium
barium10313512barium
cambium1537312cambium
erbium1038072erbium
kalium1239472kalium
labarum1166012labarum
labia75219002labi_a
labial84714332labial
labile8315212labile
labour84210932labour
labrums1175852labrums
larum74317972la_rum
pablum1237502pablum
radium93513292radium
abeam9316533_abeam
abide86223703_abide
abohm1247973_abohm
about75229083_about
abut66834953_ab_ut
abysm12598143_abysm
aecium10410423aecium
agism84614063_agism
aim57858213_a_i_m
alarum85411983alarum
albino839923albino
albite8313303albite
albums10198273alb_ums
algum82711763_algum
alliums957973alliums
alodium1047583alodium
alum65227613_a_lum
arum66129033_a_rum
atrium8411823atrium
aurum7614963_aurum
axiom143913593_axiom
babied114913503babied
babier103515563babier
babies106123643babies
babu85829223bab_u_
babul96317713bab_ul
babus95620333bab_us
bariums1139143bariums
bum75342693__b_um
cabin94820933cabi_n
cabins104418913cabins
cadmium1446113cadmium
caecum1238183caecum
caesium1158833caesium
caladium1347023caladium
calcium1368593calcium
cambism1538023cambism
cambiums1644923cambiums
cerium10313763cerium
cesium1039583cesium
cilium104311373cilium
cladism1238553cladism
claim95616913cla_i_m
conium10415313conium
corium10315723corium
cranium11911103cranium
cubism12348693cubism
curium10312503curium
dadgum1134583dadgum
datum8310633da_tum
dubnium1244183dubnium
eluvium1244973eluvium
erbiums1135463erbiums
fanum10313443fa_num
favism1437913favism
folium11310453folium
gabies93820723gabies
gabion93211023gabion
gallium1037943gallium
gaum75726423ga__um
gonium949803gonium
habile11515203habile
habit103027013habi_t
habits113014643habits
habitue12266703habitue
habitus12338173habitus
habu97325483hab_u_
habus106317143hab_us
hafnium1544243hafnium
hahnium1544433hahnium
hakim14311823haki_m
hassium1236133hassium
helium112311253helium
ilium74614173_ilium
indium939493indium
ionium8610913ionium
jabiru15125503jabiru
jabirus1694573jabirus
kabiki1134773kabiki
kaliums1336603kaliums
lab58864783lab___
labara83712893labara
labarums1254503labarums
labdanum1342923labdanum
label75019383lab_el
labellum1274273labellum
labels84515683labels
labials9299873labials
labiate91313573labiate
labor75117313lab_or
labors84016403labors
labours9349883labours
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
lambie103213663lambi_e
lambier113611633lambier
lambies113015103lambies
lambing123412403lambing
lamia75324323lami_a
lamiae84817453lamiae
lamias85020613lamias
lamina84920443lamina
laming94528363laming
langue71012173langue
langur7109303langur
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
libido935743libido
linum7313823l_inum
lithium1245823lithium
locum94812173l_ocum
lubing94114033lubing
lum55542933l___um
luteum837783luteum
lyceum1343953lyceum
lyrism1137473lyrism
magnum1136733magnum
maim85831473ma_i_m
maxim165216003maxi_m
maximum1743573maximum
medium113711623medium
milium104712673milium
minium106014413minium
nabis76020573nabi_s
nanism8311203nanism
natrium948983natrium
niobium1144713niobium
oakum1177313oa_kum
odium83413033_odium
oidium959813oidium
onium73115533_onium
opium92812093_opium
osmium1036573osmium
ostium8310133ostium
pablums1345123pablums
pabulum1344473pabulum
pallium1149013pallium
panicum1346393panicum
papism122211513papism
platinum1245443platinum
podium112911913podium
rabic93817393rabi_c
rabid84520773rabi_d
rabies85226013rabies
racism103214193racism
radiums10299303radiums
radius73914863radius
sabin74924943sabi_n
sabine84020383sabine
sabins85521973sabins
sabir75916993sabi_r
sabirs85414623sabirs
sacrum103910143sacrum
sadism94113493sadism
sagum8512873sa_gum
sebum93814553seb_um
sodium92111443sodium
solarium1078263solarium
solatium1067603solatium
stadium1038073stadium
stibium1145843stibium
subgum1136133subgum
tabid84418253tabi_d
tabour84011313tabour
tabu66328493tab_u_
tabun75914373tab_un
tabus74820923tab_us
talcum1036953talcum
tedium9269873tedium
telium82611393telium
terbium1147293terbium
uranium9610023uranium
vacuum1334833vacuum
velarium1347073velarium
wampum15406053wampum
zoarium1846093zoarium

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162526.89316352.2
3Display Results2522520.1102290.9
 (SQL Overall)1786912527.14325016.2
 
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.