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

138 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
organic103831(None) 
organics1146381organics
inorganic1243942inorganic
oceanic1146162oceanic
organ6915392organ__
organa789212organ_a
organdie1096122organdie
organdy1254572organdy
organise939322organise
organism1148392organism
organist9411542organist
organize1849092organize
organon845912organon
organs7912912organ_s
organum1045342organum
organza1793462organza
orgasmic1363632orgasmic
orgastic11116212orgastic
orgic8311822org__ic
orogenic11109362orogenic
uranic82315182ur_anic
agamic113110563_agamic
agaric93513633_agaric
aggadic1254793aggadic
agonic93515143_agonic
agravic1345893agravic
arabic10312733ar_abic
argali75013753argali_
argalis84214193argalis
argentic1149023argentic
argotic10310273argotic
arsenic939323arsenic
boracic1338723bor_acic
boronic11311163bor_onic
botanic1159583botanic
crania82418433cr_ania
cryonic1437833cryonic
cyanic133110773_cyanic
dryadic1443623dryadic
ergastic11106623ergastic
ergodic1145503ergodic
ergotic1049713ergotic
erogenic111110543erogenic
erratic9311113erratic
eugenic1038603eugenic
franc104615413fr_an_c
frantic12310363fr_antic
gamic103916203__gamic
genic85119393__genic
germanic1367503germanic
gigantic1244303gigantic
hagadic1445863hagadic
hormonic1568153hormonic
irenic8311103ir_enic
ironic8313773ir_onic
logania847833logania
manganic1346993manganic
manic94629433__manic
margaric1346063margaric
melanic11310403melanic
morainic12125673morainic
morgan9311373morgan__
morganatic1553273morganatic
morganite1247423morganite
morgans10310123morgan_s
moronic11311863mor_onic
nirvanic1342253nirvanic
nonorganic1354183nonorganic
obconic1346353obconic
octadic1245713octadic
oghamic1544043oghamic
oogonia846483oogonia
opsonic1137253opsonic
orang65119943or_an_g
orange74016323or_ange
orangs74116033or_angs
orangy105111233or_angy
ordain7810403orda_in
ordains879653ordains
orectic1138823orectic
oregano846253oregan_o
oreganos945553oreganos
organdies1187213organdies
organicism1553553organicism
organicist1354973organicist
organicity1654153organicity
organised1146353organised
organiser1045483organiser
organises1048683organises
organismic1552513organismic
organisms1247213organisms
organists1047383organists
organized2047543organized
organizer1946753organizer
organizes1948753organizes
organons945583organons
organums1143883organums
organzas1853263organzas
organzine1944203organzine
orgasm966303orga_sm
orgasms1054293orgasms
orgiac934993org_iac
orgiastic1243693orgiastic
orgone71110913orgon_e
orgones81010793orgones
origami1045453origami_
origamis1145283origamis
origan7310693origan__
origans839973origan_s
origanum1143393origanum
ornis54616773or__nis
orphic1368323or_phic
osmatic11179983osmatic
ovonic11288183o_vonic
oxalic1537093o_xalic
oxygenic2143793oxygenic
ozonic17308943o_zonic
panic93923903__panic
pianic103714123_pianic
priapic1346023priapic
puranic11410483puranic
rabic93817403_r_abic
rani46640103_r_ani_
ranid66429333_r_anid
ranis55235833_r_anis
romantic1249233romantic
runic73615773_r_unic
satanic939933satanic
siganid947203siganid
tetanic9810133tetanic
titanic968553titanic
tornadic1144843tornadic
tragic93811543tr_agic
triadic1037833triadic
urania62516123ur_ania
uratic83016353ur_atic
volcanic1544773volcanic
zoogenic2045973zoogenic

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.1531167915.0
2DLD Change Limit1340271387.39318128.9
3Display Results1381380.0463000.0
 (SQL Overall)1786911387.59223536.7
 
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.