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

214 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
niobic103723(None) 
anionic9312872anionic
bionic103614572bionic
biopic123710672biopic
biotic103816602biotic
iodic84816742_iodic
ionic74622652_ionic
limbic12528722limbic
miotic103715742miotic
nimbi94910292nimbi_
niobite937942niobite
niobium1144712niobium
nitric82512062nitric
phobic153010062phobic
pionic103515952pionic
abiotic11510453abiotic
aeonic83517043aeonic
aerobic11310213aerobic
agonic93515143agonic
aioli5318313aioli_
aiolis6316843aiolis
amebic1239103amebic
amnionic1245603amnionic
amniotic1246403amniotic
amoebic1346153amoebic
anisic8313793ani_sic
anodic92813133anodic
anomic102516303anomic
anoxic152610673anoxic
arabic10312733arabic
atomic104115603atomic
atonic83420473atonic
atopic103514143atopic
avionic1237693avionic
axonic154312723axonic
azoic162912063azo_ic
azonic175513153azonic
azotic172711623azotic
bionics114310873bionics
biontic1148333biontic
biopics13318533biopics
biopsic1345523biopsic
bioptic1337563bioptic
biotics113812173biotics
biotin83215823biotin
boobie104015293boobie
boric98024223_boric
bromic122412693bromic
choric133515893choric
citric102812303citric
civic123412543ci_vic
clonic104914673clonic
cobia94117503_cobia
colic95726173_colic
comic114721813_comic
conic95329793_conic
cubic114313413_cubic
dhobi1136963dhobi_
dhobis1236103dhobis
diobol936883diobol
dioxid1568393dioxid
dioxin14118783dioxin
dipodic1397593dipodic
disomic1238763disomic
dobie84920323_dobie
domic104317243_domic
doobie94712683doobie
eidolic1047063eidolic
enolic8413353enolic
entopic1149953entopic
erotic82620263erotic
exonic153211413exonic
exotic153112643exotic
filmic13348453filmic
fistic11812573fistic
folic105319323_folic
frolic1149203frolic
geodic1048003geodic
globin9309723globin
gnomic11248593gnomic
iambic12468253iambic
ibis66519563_i_bis
iconic10411593iconic
ictic9311793_ictic
idiotic1037453idiotic
iodid74315523_iodid
iodin64419343_iodin
ionics84214473_ionics
ironic8313773ironic
kaonic1238763kaonic
kibbi13449263kibbi_
kibbis14398463kibbis
kilobit13126883kilobit
limbi96513793limbi_
limnic10418833limnic
lithic1139493lithic
litotic939233litotic
logic88217833_logic
lotic76420663_lotic
meiotic11410923meiotic
microbic1647213microbic
mimic111414313mi_mic
miosis83615163miosis
miotics112710653miotics
mitotic1139703mitotic
muonic10410183muonic
myopic15308463myopic
myotic133112303myotic
nabis76020573n_abis
naoi46024633nao_i_
naric76824173n_aric
nastic82915963nastic
nepotic11310553nepotic
neumic1036853neumic
newbie11135413newbie
niacin8310223niacin
nib56745183ni_b__
nibbed114311903nibbed
nibbing12339543nibbing
nibble103713283nibble
niblick1544453niblick
nibs65028303ni_b_s
nicotin948373nicotin
nidi56524393ni_di_
nihil8410283ni_hil
nimble103412933nimble
nimbly13388763nimbly
nimbus10377273nimbus
niobate937703niobate
niobites1037313niobites
niobiums1243373niobiums
niobous936323niobous
nisei54214353nisei_
niseis63512023niseis
nisi45823243ni_si_
nitid61817833ni_tid
nitpick1543783nitpick
nitrid72812233nitrid
nitril62511533nitril
nitrolic1046813nitrolic
nitwit938593nitwit
nixie125114943ni_xie
nob58954423n_ob__
nobby125513453n_obby
noble74420993n_oble
nobly105314403n_obly
nobs66436903n_ob_s
nodi56626743n_odi_
noetic8514043noetic
noil46133243n_o_il
noir46722433n_o_ir
nonionic1049233nonionic
noogie73612313noogie
nookie103712433nookie
nordic939473nordic
nori47133143n_ori_
noria55722183n_oria
noris54928273n_oris
notice8313443n_otice
novice1138433n_ovice
nubbin10308283nubbin
nubia7311223n_ubia
obi57127723__obi_
obia67923103__obia
obis66226833__obis
obit66837073__obit
odic74920573__odic
otic66624813__otic
ovonic11288183ovonic
ozonic17308943ozonic
phobia13278593phobia
phobics16286703phobics
phonic133315203phonic
photic133316423photic
pianic103714123pianic
picnic123410263picnic
picric12309923picric
probit103218353probit
ptotic102713363ptotic
pubic114513713_pubic
rabic93817393_rabic
rhodic12227223rhodic
rhombic16264523rhombic
rhotic112711213rhotic
robin74820273_robin
sialic8313633sialic
sodic84917483_sodic
sonic75225283_sonic
sorbic10310383sorbic
stoic7317243sto_ic
strobic1138243strobic
terbic10410963terbic
thiolic1247303thiolic
thionic1238873thionic
thoric114314033thoric
tibia7312393ti_bia
tidbit938483tidbit
titbit839813titbit
tonic74727653_tonic
topic95721503_topic
toric76529313_toric
toxic145315623_toxic
tropic103014193tropic
uncomic1346923uncomic
unific1137463uni_fic
unironic1046053unironic
viatic11311453viatic
vinic10314973vi_nic
violin9311983violin
vitric112510113vitric
yogic116114933_yogic
yonic105920843_yonic
zincic1935903zincic
zoic152316073_zo_ic

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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162146.48617378.4
3Display Results2142140.0762815.8
 (SQL Overall)1786912146.71826598.8
 
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.