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 “obconic” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
obconic134635(None) 
bionic103614572_bionic
boronic11311162boronic
bosonic1139212bosonic
conic95329792__conic
iconic10411592_iconic
laconic1139882laconic
obconical1544172obconical
opsonic1137252opsonic
ovonic11288182o_vonic
ozonic17308942o_zonic
abiotic11510463abiotic
acinic104713543_acinic
acronic112814693acronic
aeonic83517043_aeonic
agonic93515143_agonic
ammonic1349163ammonic
anionic9312873anionic
aphonic142713393aphonic
atonic83420473_atonic
avionic1237693avionic
axonic154312723_axonic
azonic175513153_azonic
bionics114310873_bionics
biontic1148333_biontic
biopic123710673_biopic
biotic103816613_biotic
boric98024223_b_oric
botanic1159583botanic
bromic122412693_bromic
bronc91714343_bron_c
bubonic1366243bubonic
bucolic1345593bucolic
canonic11312933canonic
chronic14311423chronic
clonic104914673_clonic
colic95726173__colic
colonic115015713colonic
comic114721813__comic
coni65534803__coni_
conics103920593__conics
conin76232723__conin
cryonic1437833cryonic
cyclonic1446973cyclonic
cynic124712423__cynic
demonic12311223demonic
draconic1346193draconic
ebonics1137193eb_onics
ecbolic1345623ecbolic
exonic153211413_exonic
glyconic1644613glyconic
hedonic1339043hedonic
hormonic1568153hormonic
ionic74622663__ionic
ironic8313773_ironic
kaonic1238763_kaonic
ketonic1349923ketonic
lactonic1248043lactonic
masonic1139913masonic
mesonic11310093mesonic
moronic11311863moronic
muonic10410183_muonic
mycotic1647713mycotic
nonionic1049233nonionic
nontonic10410153nontonic
oblong935383oblon_g
oblongs1033533oblongs
oboli73712873ob_oli_
oceanic1146163oceanic
oncogenic1446123oncogenic
oogonia846483oogonia
oologic1049423oologic
opsonin946013opsonin
organic1038313organic
osmotic11127613osmotic
ovonics12245553o_vonics
phonic133315213_phonic
picnic123410263pic_nic
pionic103515953_pionic
pleonic1139433pleonic
robotic1139223rob_otic
scenic10510513_scenic
sonic75225293__sonic
subsonic1245753subsonic
subtonic1246923subtonic
syconia1248313syconia
technic1496903technic
tectonic1248453tectonic
thionic1238893thionic
tonic74727653__tonic
tyronic1239313tyronic
umbonic1365463umbonic
uncomic1346923uncomic
vibronic1545133vibronic
volcanic1544773volcanic
yonic105920843__yonic
zirconic2144013zirconic

Search took 7 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 Limit134027976.45020779.4
3Display Results97970.0332939.4
 (SQL Overall)178691976.88925938.6
 
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.