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

242 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
biopic12371067(None) 
bionic103614571bionic
biopics13318541biopics
biopsic1345521biopsic
bioptic1337561bioptic
biotic103816611biotic
abiotic11510462abiotic
atopic103514142atopic
bionics114310872bionics
biontic1148332biontic
biopsy1334532biopsy
biotics113812172biotics
biotin83215832biotin
biotypic1744402biotypic
boric98024222b_oric
bromic122412692bromic
iodic84816752_iodic
ionic74622662_ionic
miotic103715752miotic
myopic15308462myopic
niobic1037242niobic
pionic103515952pionic
topic95721502_topic
tropic103014192tropic
abiosis939373abiosis
adipic1137263adipic
aeonic83517043aeonic
agonic93515143agonic
aioli5318313aioli_
aiolis6316843aiolis
anionic9312873anionic
anodic92813133anodic
anomic102516303anomic
anopia83412393anopia
anoxic152610673anoxic
aspic95114733_aspic
atomic104115603atomic
atonic83420473atonic
atypic13337653atypic
avionic1237693avionic
axonic154312723axonic
azoic162912063azo_ic
azonic175513153azonic
azotic172711633azotic
bardic11312923bardic
baric96125693b_aric
basic96220523b_asic
beylic1337823beylic
biali73419073biali_
bialis83617163bialis
bibasic1345643bibasic
bidi78226593bi_di_
bidis86721143bi_dis
biffin14369103biffin
bifid11910703bi_fid
biggie103810933biggie
biggin103710603biggin
bigwig1333343bigwig
bikie113915883bi_kie
billie85019173billie
bindi85617013bindi_
bindis94614583bindis
binit76431583bi_nit
bio57846083bio___
biochip1645323biochip
biocide1237323biocide
bioethic1544693bioethic
biofilm1444333biofilm
biog76122323bio__g
biogas94310913biogas
biogen9310253biogen
biogenic1347823biogenic
biogs85016113bio_gs
biologic1348273biologic
biolytic1546773biolytic
biome94916993bio_me
biomes103815253biomes
bionomic1476153bionomic
biont7727163bio_nt
bionts8612393bionts
biopiracy1851573biopiracy
biopsied1344593biopsied
biopsies1237383biopsies
bios66335323bio__s
biota74516823bio_ta
biotas84313923biotas
biotech14104493biotech
biotical1248863biotical
biotins93114453biotins
biotite9311033biotite
biotitic1247573biotitic
bipack1636523bi_pack
biped104718833bi_ped
bipod104410823bi_pod
bipods11408593bipods
birdie94013783birdie
birkie124110133birkie
bishopric1852063bishopric
bivouac1442573bivouac
bloc85023273blo__c
blooie83913193blooie
bocci113512713b_occi
bodice11711423b_odice
bogie89524103b_ogie
boil66335183b_o_il
boobie104015293boobie
boogie93515993boogie
bookie123516003bookie
bootie85421163bootie
bop77549483b_op__
bops86037983b_op_s
boronic11311163boronic
bosonic1139213bosonic
bovid111011623b_ovid
broil74918223bro_il
bromid112612893bromid
bromin102615693bromin
bronc91714343bro_nc
bubonic1366243bubonic
bucolic1345593bucolic
buppie12288733buppie
bustic101012693bustic
canopic1338803canopic
chopin132712193chopin
choric133515903choric
citric102812313citric
civic123412543ci_vic
clonic104914673clonic
colic95726173_colic
comic114721813_comic
conic95329793_conic
diapir9357113diapir
dioptric1345633dioptric
dioxid1568393dioxid
dioxin14118783dioxin
diplopic1545593diplopic
dipodic1397593dipodic
disomic1238763disomic
domic104317243_domic
ectopic1338153ectopic
eidolic1047063eidolic
enolic8413353enolic
entopic1149953entopic
epic86921303__epic
erotic82620273erotic
exonic153211413exonic
exotic153112653exotic
filmic13348453filmic
fistic11812573fistic
folic105319323_folic
frolic1149203frolic
geodic1048003geodic
gnomic11248593gnomic
gopik1257533_gopik
hippie132811243hippie
hispid1238173hispid
iconic10411593iconic
ictic9311803_ictic
idiotic1037463idiotic
impi85415793_impi_
impis96213853_impis
iodid74315533_iodid
iodin64419353_iodin
ionics84214483_ionics
ironic8313773ironic
kaonic1238763kaonic
limbic12528743limbic
limnic10418843limnic
limpid11389753limpid
lipid85916173li_pid
lipin75518893li_pin
lipoid9411043lipoid
lithic1139493lithic
litotic939243litotic
logic88217833_logic
lotic76420673_lotic
meiotic11410933meiotic
meropic13310263meropic
metopic1339763metopic
mimic111414323mi_mic
miosis83615163miosis
miotics112710653miotics
mitotic1139713mitotic
muonic10410183muonic
myopia13318443myopia
myotic133112313myotic
nitpick1543783nitpick
nitric82512063nitric
obconic1346353obconic
odic74920573__odic
optic93715183__optic
otic66624823__otic
ovonic11288183ovonic
ozonic17308943ozonic
phobic153010073phobic
phonic133315213phonic
photic133316443photic
pianic103714123pianic
pic76046823___pic
picnic123410263picnic
picric12309923picric
pipit95224873pi_pit
pippin92810303pippin
priapic1346023priapic
ptotic102713373ptotic
rhodic12227233rhodic
rhotic112711233rhotic
sepic94617053_sepic
sialic8313633sialic
sinopia947743sinopia
sinopie948783sinopie
sodic84917493_sodic
sonic75225293_sonic
spic85227433__spic
stoic7317253sto_ic
subtopic1445073subtopic
thiolic1247323thiolic
thionic1238893thionic
thoric114314043thoric
tiepin839343tiepin
tipi69924433ti_pi_
tipis76019923ti_pis
tonic74727653_tonic
topi67830393_topi_
topics104714583_topics
topis76025833_topis
toric76529313_toric
toxic145315623_toxic
trophic14311033trophic
tropics113610653tropics
tropin83316753tropin
typic124511963_typic
utopia8107883utopia
viatic11311453viatic
vinic10314973vi_nic
violin9311983violin
vitric112510113vitric
yippie13277843yippie
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.376475242.0
2DLD Change Limit1127162425.95318934.3
3Display Results2422420.0932602.2
 (SQL Overall)1786912426.42227824.8
 
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.