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

151 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
biontic114833(None) 
bionic103614571bion_ic
bioptic1337561bioptic
biotic103816601bio_tic
abiotic11510452abio_tic
bioethic1544692bioethic
biolytic1546772biolytic
bionics114310872bion_ics
bionomic1476152bionomic
biont7727162biont__
bionts8612392biont_s
biopic123710672bio_pic
biopsic1345522biopsic
biotics113812172bio_tics
biotin83215822bio_tin
biotitic1247572biotitic
deontic1038882deontic
ionic74622652_ion_ic
miotic103715742mio_tic
ontic74418572__ontic
pionic103515952pion_ic
aconitic1239513aconitic
aeonic83517043aeon_ic
agonic93515143agon_ic
albinotic1343633albinotic
aloetic9313183aloetic
anionic9312873anion_ic
antic75728863__antic
aortic8316613_aortic
atonic83420473aton_ic
avionic1237693avion_ic
axonic154312723axon_ic
azonic175513153azon_ic
azotic172711623azo_tic
barytic1437823barytic
benthic1437473b_enthic
bibasic1345643bibasic
bicentric1544283bicentric
biennia994933biennia
bigstick1744283bigstick
bindi85617013bi_ndi_
bindis94614583bi_ndis
binit76431583bi_n_it
binits85716673bi_nits
bint67355033bi_nt__
bints76130183bi_nt_s
biochip1645323biochip
bioethics1643843bioethics
biogenetic1544823biogenetic
biogenic1347823biogenic
biologic1348273biologic
biometric1548463biometric
bionomics1574583bionomics
bionomy1444723bionomy
biopics13318533bio_pics
biota74516823bio_t_a
biotas84313923bio_tas
biotech14104493bio_tech
biotical1248863bio_tical
biotins93114453bio_tins
biotite9311033bio_tite
biotypic1744403biotypic
bisontine1145673bisontine
bonaci10310963b_onaci
bonduc1136603b_onduc
bonita8312943b_onita
bonito8313433b_onito
bonnie85314853b_onnie
bootie85421153b_ootie
boric98024223b_o_ric
bornitic1246473bornitic
boronic11311163boron_ic
bosonic1139213boson_ic
bromic122412693bro_mic
bronc91714343bron__c
bubonic1366243bubon_ic
bustic101012693b_ustic
cantic103920533_cantic
clonic104914673clon_ic
conic95329793_con_ic
coontie9311413coontie
dioptric1345623dioptric
dioritic1149493dioritic
diplontic1444523diplontic
eidetic1039743eidetic
erotic82620263ero_tic
exonic153211413exon_ic
exotic153112643exo_tic
fistic11812573fi_stic
frantic12310363frantic
gerontic1147963gerontic
gigantic1244293gigantic
glottic1036643glottic
gnostic1038433gnostic
iconic10411593icon_ic
ictic9311793_i_ctic
identic1038043identic
idiotic1037453idio_tic
inti46626073_i_nti_
intis55121633_i_ntis
iodic84816743_io_dic
ionics84214473_ion_ics
iritic83213823_iritic
ironic8313773iron_ic
kaonic1238763kaon_ic
kenotic1359703kenotic
kinetic13209173kinetic
lentic83515743_lentic
lignitic1146393lignitic
limnetic1255583limnetic
limnic10418833limn_ic
limonitic1344403limonitic
litotic939233litotic
lotic76420663_lo_tic
mantic104120903_mantic
meiotic11410923meio_tic
mimetic1338643mimetic
miotics112710653mio_tics
mitotic1139703mitotic
muonic10410183muon_ic
myotic133112303myo_tic
niobic1037233nio_bic
noetic8514043_noetic
obconic1346353obcon_ic
optic93715183__optic
otic66624813__o_tic
ovonic11288183ovon_ic
ozonic17308943ozon_ic
phonetic15310313phonetic
phonic133315203phon_ic
photic133316423pho_tic
pianic103714123pian_ic
picnic123410263picn_ic
piratic11314293piratic
poetic10416843_poetic
pontil8315463_pontil
psoatic1139303psoatic
ptotic102713363pto_tic
quantic18279063quantic
quintic18308883quintic
rhotic112711213rho_tic
sonic75225283_son_ic
strontic1048093strontic
thionic1238873thion_ic
tonetic9313433_tonetic
tonic74727653_ton_ic
viatic11311453vi_atic
vinic10314973vi_n_ic
yonic105920843_yon_ic
zincic1935903zi_ncic
zoonotic1945323zoonotic

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.1561145455.1
2DLD Change Limit1340271517.20318607.1
3Display Results1511510.0463282.6
 (SQL Overall)1786911517.40524131.1
 
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.