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

234 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
origans83997(None) 
organs7912911or_gans
origan7310691origan_
origins8310461origins
brigand1136642brigand
brigands1245622brigands
brogans1049662brogans
ligans76817732_ligans
morgans10310122mor_gans
oregano846252oregano
oreganos945552oreganos
organ6915392or_gan_
organa789212or_gana
origami1045432origami
origamis1145262origamis
origanum1143392origanum
origanums1242432origanums
origin7311032origin_
orisons7310562orisons
orphans1237772orphans
trigons84312092trigons
wigans104511702_wigans
aligns75312953alig_ns
amigas95912163amiga_s
argals75517703ar_gals
argons75018203ar_gons
arias55438023ari_a_s
artisans888523artisans
avians93711563avi_ans
bogans95714813_bogans
brans75437433br__ans
briars84814823bri_ars
bridals1038623bridals
brigade1136493brigade
brigades1236393brigades
brights133710233brights
brigs85823223brig__s
brins75533973bri__ns
brisant9312683brisant
brogan9311043brogan_
caimans113811783caimans
cardigans1345143cardigans
cigars9910713_cigars
coigns94410063coig_ns
corbans11313173cor_bans
coreigns1136313coreig_ns
cosigns1047513cosig_ns
deigns8389983deig_ns
divans104612393_divans
diwans105110373_diwans
dragons938383dragons
durians839573duri_ans
epigons1048183epigons
ericas8315463erica_s
feigns10407753feig_ns
firmans12238523firmans
florigens13133863florigens
friars93812093fri_ars
frigate11311063frigate
frigates12310923frigates
friges104116483frig_es
frights14339623frights
frigs96019273frig__s
frypans1544053frypans
gigas75415583_giga_s
gorgons938853gor_gons
grans64832543gr__ans
grigris934093grigris
grigs75318193grig__s
gringas938033gringa_s
grins65427223gri__ns
grisons838993grisons
groans74815063gr_oans
harijans1845723harijans
hogans105914313_hogans
hooligans1342823hooligans
horizons2045463horizons
jordans1566833jor_dans
kurgans12145653kurgans
lagans75717783_lagans
larrigans1044013larrigans
ligan67920283_ligan_
ligand85011293_ligand
ligands9438983_ligands
lignans8398853_lignans
limans84816303_limans
logans76319063_logans
longans84510813longans
lorans65117603lor__ans
lungans8399053lungans
magians10310753magians
morgan9311373mor_gan_
morgens10310463mor_gens
morions94014633mori_ons
norias65518183nori_a_s
obias76116853obi_a_s
oceans81211003o_ceans
ocicats11137413ocicats
octans81411143o_ctans
ogams84112683o__gams
ohias84415563ohi_a_s
oilcans936813oilcans
omegas936973omega_s
onions64016433oni_ons
oppidans1343083oppidans
orals55826483or__als
orang65119943or__ang
orangs74116033or__angs
orbitals1045713orbitals
orcas75918623or_ca_s
orceins937743orceins
orcins83313433or_cins
ordains879653ordains
ordeals877993ordeals
ordinals946743ordinals
ordinand1044103ordinand
ordinands1143033ordinands
oreads73915773or_eads
orfrays1343533orfrays
organdy1254573or_gandy
organic1038313or_ganic
organics1146383or_ganics
organise939323or_ganise
organism1148393or_ganism
organist9411543or_ganist
organon845913or_ganon
organons945583or_ganons
organum1045343or_ganum
organums1143883or_ganums
organza1793463or_ganza
organzas1853263or_ganzas
orgasm966303or_gasm
orgasms1054293or_gasms
orgeats838353orgeats
orgiac934993orgia_c
orgiast837463orgiast
orgiasts943803orgiasts
orgies72316093or_gies
orgone71110913or_gone
orgones81010793or_gones
oribis838833ori_bis
oriels64914623ori_els
orient6322533ori_ent
orients7311583orients
original956793original
originals1044843originals
orioles7412993orioles
orishas1036473orishas
orison6411663orison_
orlons6411013or_lons
orogeny11107023orogeny
orphan1137733orphan_
orpins83614163or_pins
ortolans846553ortolans
outgains9810163outgains
outgas7313203outga_s
outguns8318693outguns
outmans92413283outmans
ovisacs1263283ovisacs
oxidant1547363oxidant
oxidants1643933oxidants
oxygens1843163oxygens
pagans95717923_pagans
paisans93614753paisans
parians93519733pari_ans
perigons11310083perigons
pians75126963_pi_ans
prigs85219703prig__s
primas104418103prima_s
prions84317783pri_ons
prisons9313223prisons
prolans9314273prolans
ptisans9317363ptisans
puritans1037633puritans
ragas65326063_raga_s
raglans82410133_raglans
ratans63819373_ratans
redans75421023_redans
regains84316583_regains
reigns74811753reig_ns
remans84823003_remans
rials55026673_ri_als
riant55833153_ri_ant
rias45540593_ri_a_s
riband9239623_riband
ribands10208393_ribands
ricins83618703_ricins
rights104019333_rights
rigors72813713_rigors
rigs55137593_rig__s
rins46153193_ri__ns
ripens85012173_ripens
rivals94213183_rivals
riyals94111083_riyals
roans54926443_r_oans
romans84620243_romans
rowans95715343_rowans
saigas74114293saiga_s
seitans73312303seitans
signs65516323_sig_ns
slogans8407983slogans
taigas73712553taiga_s
taipans9269553taipans
tigons74112253_tigons
titans63414913_titans
trans54933043tr__ans
trapans92812463trapans
trepans92311593trepans
triacs83913223tri_acs
triads74513523tri_ads
triages82613793triages
trials64319883tri_als
tribals9610743tribals
triens65417543tri_ens
trigon74513103trigon_
trigos74214173trig_os
trigrams11116343trigrams
trigs65423063trig__s
triptans1047363triptans
tritons73814883tritons
trogons83410713trogons
tzigane1742933tzigane
tziganes1853013tziganes
urials64415193uri_als
urinals7610253urinals
vegans103910853_vegans
vigas94817883_viga_s
virgas1048883virga_s
virgins1137863virgins
wangans1149503wangans
wanigans1244743wanigans
wigan95114393_wigan_
witans93412933_witans
wrights14318993wrights

Search took 10 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.310576422.6
2DLD Change Limit1340272348.53315706.9
3Display Results2342340.0763078.9
 (SQL Overall)1786912348.91920034.9
 
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.