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

135 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
halogen113839(None) 
halogens1237361halogens
hyalogen1544051hyalogen
chalcogen1743762chalcogen
haloed104717602halo_ed
haloes94623862halo_es
halogeton1372812halogeton
halon86124862halo__n
hyalogens1643772hyalogens
acrogen1038203acrogen
algin65718763_al_gin
alien56425583_al_ien
align65016503_alig_n
aloe45540193_alo_e_
aloes54933673_alo_es
aloin55227423_alo_in
alone55732963_alone_
amylogen1444263amylogen
anlagen8238643anlagen
apogean1045443_apogean
apogee9312563_apogee
awoken13457163_awoken
baclofen1543103baclofen
baleen8613053bal_een
baloney1237483baloney
biogen9310253_biogen
calomel1138073calomel
caloyer1238143caloyer
chalcogens1852993chalcogens
chalone12312103chalone_
chalones13312173chalones
cloven114211513_cloven
cologne1039363cologne
cryogen1345043cryogen
cyanogen14104513cyanogen
dialoged1146693dialoged
dialoger1056083dialoger
endogen938613endogen
exogen1436513_exogen
fallen93813373fal_len
galoped11138083galoped
galore73514873galore_
galores82614343galores
gasogene1045303gasogene
gazogene1943553gazogene
hackmen1836713hackmen
haen76229453ha___en
hagged124317703ha_gged
halcyon1543923halcyon
hale76052833hal__e_
haled95335823hal__ed
haler85033523hal__er
hales85449843hal__es
halide103417993halide_
halides113416663halides
halite93624233halite_
halites103221193halites
hallel93514093hal_lel
halloaed121510153halloaed
halloed113314913halloed
halloes104021523halloes
hallooed12168773hallooed
hallowed15179493hallowed
hallower14139813hallower
halo76437323halo___
halogenate1454323halogenate
halogenous1453953halogenous
halogetons1452713halogetons
haloid104317763halo_id
haloids113012553haloids
haloing113814133haloing
halons95720713halo_ns
halos85230253halo__s
halted105019603hal_ted
halter94420883hal_ter
halve114818923hal_ve_
halved134813903hal_ved
halves124717093hal_ves
handgun1244623handgun
hanged114222393ha_nged
hanger104023253ha_nger
hangmen1337383hangmen
haole84820083ha_ole_
haoles94919803ha_oles
haploses1338853haploses
happen134812193ha_ppen
hapten115312983ha_pten
harden105718533ha_rden
harken135116343ha_rken
harshen1339283harshen
hasten95718563ha_sten
haulage1136913haulage_
haulages1236623haulages
hausen9610383ha_usen
haven114718533ha__ven
haylage1436443haylage_
haylages1536013haylages
histogen1245563histogen
hogan97817703h__ogan
holden104113953hol_den
holocene1346143holocene
hologyny1843143hologyny
holpen11299413hol_pen
homogeny1745633homogeny
hosen85623883h__osen
hydrogen1646283hydrogen
hypogea1645473hypogea
hypogean1744993hypogean
hypogene1746943hypogene
ionogen837123ionogen
kerogen1236093kerogen
loden66621143__loden
logan68123283__logan
loge56837193__loge_
loges66534203__loges
login66025003__login
logon615922313__logon
lysogen1144363lysogen
malign939853malig_n
mitogen1036963mitogen
paleogene1245233paleogene
pangen94115913pa_ngen
pathogen1446463pathogen
phellogen1543653phellogen
phylogeny2143753phylogeny
pirogen1038263pirogen
pyrogen1337353pyrogen
salon55228553salo__n
saloon64418023salo_on
slogan7539223_slogan
sloven9389633_sloven
talon55824113talo__n
taloned8310223taloned
whalemen1644473whalemen
zymogen2243693zymogen

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 Limit1340271357.34318252.3
3Display Results1351350.0632142.9
 (SQL Overall)1786911357.81222873.9
 
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.