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

222 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
orgasm96630(None) 
orgasms1054291orgasms
ogam75120032o_ga_m
ogams84112682o_gams
ogrism937912ogrism
orcas75918622orcas_
organ6915392orga_n
organa789212organa
organism1148392organism
organs7912912organs
organum1045342organum
orgasmed1242932orgasmed
orgasmic1363632orgasmic
orgiast837462orgiast
agas55938843_agas_
agism84614063_agism
algas65624933algas_
angas65827993angas_
aortas65417783aortas_
areas55935773areas_
argal65023393arga_l
argala74712673argala
argali75013753argali
argals75517713argals
argosy1036423argosy
argus66716543argus_
arias55438023arias_
arras55626133arras_
avgas96912133avgas_
bagass938933bagass
boras75938303bor_as_
boreas85421733boreas_
brags85625103brags_
bras65746453br_as_
brash106221563br_ash
brass75428023br_ass
bream95121813brea_m
breams104815043breams
breast8319633breast
chasm125518793_chasm
chiasm13449103chiasm
congas94417033congas_
corgis9314413corgis_
crags85622573crags_
cram85635493cr_a_m
crams96229153cr_ams
crash109120013cr_ash
crass76328043cr_ass
cream95721353crea_m
creams104715253creams
crease85519573crease
creasy114612303creasy
degas75119163degas_
dongas84914613dongas_
drags75521113drags_
dram75832003dr_a_m
drams86025833dr_ams
dream85120393drea_m
dreams94513983dreams
eras45441503er_as_
erase54925493er_ase
ergate7315143ergate
ergs55523813erg_s_
foram105124933for_a_m
forams115115913for_ams
forearm1238703forearm
forgat104018583forga_t
forgave1435853forgave
forges105024263forges_
frags96322173frags_
frass85321123fr_ass
gam67060063__ga_m
gams76648883__gams
gas48870253__gas_
gash86833023__gash
gasp76227333__gasp
gast56052563__gast
gaum75726423__gaum
gigas75415583gigas_
gorges85321893gorges_
gram77034583gr_a_m
grams85327313gr_ams
grasp84814483gr_asp
grass66125203gr_ass
grease75416233grease
greasy10419463greasy
horas86333103hor_as_
joram145816983jor_a_m
jorams154810533jor_ams
koras95927113kor_as_
kormas124511243kormas_
ligase7259913ligase
megass9219443megass
miasm91211093_miasm
moras76438783mor_as_
morass84614503mor_ass
morgan9311373morga_n
morgans10310123morgans
norias65518203norias_
oast47156323o__ast
obas65730933o_bas_
obias76116863obias_
obiism1036363obiism
oblast8613663oblast
ocas66729633o_cas_
odas57230263o_das_
ogham1138253o_gham
oghams1245853oghams
ogreism1044233ogreism
ogres65818633ogres_
ogress7529503ogress
ogrish1039263ogrish
ogrisms1036443ogrisms
ohias84415573ohias_
okas85225393o_kas_
okras94410973okras_
ollas54218283ollas_
omasa749483o_masa
omasum1035503o_masum
omegas936983omegas_
oogamy1235633oogamy
ora37250833or_a__
orach105219233or_ach
orad56031693or_a_d
oral47638123or_a_l
oralism9513763oralism
orals55826483or_als
orang65119943or_ang
orate55133303or_ate
orbs66626253or_bs_
orca65522773orca__
orcs67025433or_cs_
ordain7810403ordain
ordos65216203ordos_
oread64619603orea_d
oreads73915773oreads
oregano846253oregano
ores46056683or_es_
organdy1254573organdy
organic1038313organic
organise939323organise
organisms1247213organisms
organist9411543organist
organon845913organon
organums1143883organums
organza1793463organza
orgasming1343113orgasming
orgastic11116213orgastic
orgeat7515033orgeat
orgeats838353orgeats
orgiac934993orgiac
orgiasts943803orgiasts
orgic8311823org_ic
orgies72316093orgies
orgone71110913orgone
orgy85218003org__y
origami1045453origami
origan7310693origa_n
origans839973origans
origanum1143393origanum
orles55326213orles_
ornate6315143ornate
ornis54616773ornis_
orphism1446183orphism
orra46120723orra__
orris54516553orris_
ors35750113or__s_
orts46538333or_ts_
orzos143311253orzos_
outask1039103outask
outgas7313203outgas_
plasm94114633_plasm
porism104518063por_ism
praam94815613pr_aam
praams10459643praams
pram85733493pr_a_m
prams96125513pr_ams
prase76128753pr_ase
prearm104512353prearm
prism94820263pr_ism
proas75028803proas_
ragas65326063ragas_
rags55448373_rags_
ram56867273_r_a_m
rams65950773_r_ams
ras37575393_r_as_
rase46149983_r_ase
rash76039933_r_ash
rasp66029163_r_asp
realm75621623_realm
ream65841613_rea_m
reams75729623_reams
rearm75923573_rearm
rias45540603_rias_
roam67132413_roa_m
roams74919613_roams
roast56230143_roast
rotas54827723rotas_
ryas77224613_ryas_
sagas66025883sagas_
sarcasm1136693sarcasm
soras55041013sor_as_
sorghum1343513sorghum
sorgos74514663sorgos_
spasm94514173_spasm
togas67823003togas_
tongas74315533tongas_
toras55540373tor_as_
tortas64918253tortas_
tram67034553tr_a_m
trams75327673tr_ams
trash86119763tr_ash
trass56226473tr_ass
truism8118623truism
urase54624693ur_ase
ureas55826013ureas_
urease64516993urease
urges64619913urges_
vigas94817883vigas_
virgas1048883virgas_
yogas96615603yogas_
yugas95012063yugas_

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.373479064.3
2DLD Change Limit1127162225.39320900.4
3Display Results2222220.0762921.1
 (SQL Overall)1786912225.84230587.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.