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

140 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
bosonic113921(None) 
boronic11311161boronic
bionic103614572b_ionic
boson76019732boson__
bosons85016652boson_s
botanic1159582botanic
bubonic1366242bubonic
colonic115015712colonic
eosinic947712eosinic
masonic1139912masonic
mesonic11310092mesonic
moronic11311862moronic
obconic1346352obconic
opsonic1137252opsonic
ovonic11288182_ovonic
ozonic17308942_ozonic
sonic75225292__sonic
acronic112814693acronic
aeonic83517043_aeonic
agonic93515143_agonic
ammonic1349163ammonic
anionic9312873anionic
aphonic142713393aphonic
arsenic939323arsenic
atonic83420473_atonic
avionic1237693avionic
axonic154312723_axonic
azonic175513153_azonic
baryonic1546203baryonic
basic96220523bas__ic
basilic1137493basilic
bedsonia1153753bedsonia
begonia1047213begonia
biogenic1347823biogenic
biologic1348273biologic
bionics114310873b_ionics
bionomic1476153bionomic
biontic1148333b_iontic
biopic123710673b_iopic
biosolid1144893biosolid
biotic103816613b_iotic
bison75716983bison__
bisons83914373bison_s
boloney1247763boloney
bolson8410683bolson__
bolsons969483bolson_s
boltonia1045513boltonia
bonnie85314853bo_nnie
boobie104015293bo_obie
boogie93515993bo_ogie
booing94521643bo_oing
bookie123516003bo_okie
boon67142173bo_on__
boonies93422483bo_onies
boons75031913bo_on_s
bootie85421163bo_otie
boracic1338723boracic
boric98024223b__oric
boron76727143boron__
borons85520543boron_s
bosom95516923boso__m
bosomed1238003bosomed
bosoming1336643bosoming
bosoms104913053boso_ms
bosomy13509033boso_my
bossing103714603bossing
boston8513043boston__
bostons9312903boston_s
bosun75113593bosun__
bosuns8439383bosun_s
botanica1295723botanica
botonee9311833botonee
bromic122412693b_romic
bronc91714343b_ron_c
bucolic1345593bucolic
bustic101012693bus_tic
canonic11312933canonic
chronic14311423chronic
clonic104914673_clonic
coloni85619203coloni_
colonics123711613colonics
conic95329793__conic
cosmic12410343cos_mic
cryonic1437833cryonic
demonic12311223demonic
disomic1238763disomic
dystonic1446513dystonic
exonic153211413_exonic
geoponic1347213geoponic
gnomonic1345903gnomonic
goonie73615563go_onie
hedonic1339043hedonic
hormonic1568153hormonic
iconic10411593_iconic
ionic74622663__ionic
ironic8313773_ironic
isogonic11187253isogonic
isotonic10158323isotonic
kaonic1238763_kaonic
ketonic1349923ketonic
laconic1139883laconic
loonie64216453lo_onie
monodic1269783monodic
mosaic10311143mos_aic
motoric11312233motoric
muonic10410183_muonic
myotonic1547753myotonic
nonionic1049233nonionic
nontonic10410153nontonic
oogonia846483oogonia
oologic1049423oologic
oosporic1245063oosporic
opsonin946013opsonin
osmic939913_os_mic
osmotic11127613_osmotic
ovonics12245553_ovonics
parsonic1239703parsonic
phonic133315213_phonic
photonic15312103photonic
pionic103515953_pionic
pleonic1139433pleonic
podsolic1344173podsolic
pogonia1048933pogonia
pogonip1245373pogonip
prosodic1347693prosodic
protonic12314593protonic
robotic1139223robotic
rosolio746983rosolio
sodic84917493__sodic
somoni8310743somoni_
sonics84315633__sonics
stolonic1047583stolonic
subsonic1245753subsonic
telsonic1045993telsonic
thionic1238893thionic
tonic74727653__tonic
toonie63617993to_onie
tyronic1239313tyronic
umbonic1365463umbonic
yonic105920843__yonic

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.796224486.2
2DLD Change Limit1340271406.73319906.0
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.57523589.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.