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

275 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
biotics11381217(None) 
bionics114310871bionics
biopics13318541biopics
biotic103816601biotic_
biotins93114451biotins
miotics112710651miotics
abiotic11510452abiotic_
bioethics1643842bioethics
bionic103614572bionic_
biontic1148332biontic_
biopic123710672biopic_
bioptic1337562bioptic_
biotas84313922biot_as
biotech14104492biotech
biotechs15123852biotechs
biotical1248862biotical
biotin83215822bioti_n
biotite9311032biotite
biotites10310082biotites
booties94124612booties
bustics11810882bustics
erotics91914152erotics
exotics16229192exotics
ionics84214482_ionics
miotic103715742miotic_
myotics14257592myotics
photics142810472photics
abiosis939373abiosi_s
aiolis6316843aioli_s
antics84621453_antics
arctics1138953arctics
atomics113110853atomics
atonics93613713atonics
attics84413283_attics
avionics1344953avionics
azotic172711623azotic_
banties94324763banties
basics104915123b_asics
batiks1239373b_atiks
battiks1337143battiks
bawties124214313bawties
bedtick1645233bedtick
bedticks1774163bedticks
bestirs9311133bestirs
beylics1436183beylics
bhisties1339003bhisties
bialies93618413bialies
bialis83617163biali_s
bibliotics1653173bibliotics
biddies113514493biddies
bidis86721143bi_di_s
biffies152710853biffies
biffins15358533biffins
biggies113813523biggies
biggins113410693biggins
bigotries1286443bigotries
bigots95015133bigot__s
bigstick1744283bigstick
bigtime1235753bigtime
bigwigs1443003bigwigs
bikies124515163bi_kies
bilbies114712343bilbies
billies93923503billies
bindis94614583bindi_s
binits85716673bi_nits
binocs1039923bi_nocs
bints76130183bint__s
biochips1744843biochips
biocide1237323biocide
biocides1336923biocides
bioethic1544693bioethic_
biofilm1444333biofilm
biofilms1542773biofilms
biogas94310913bio_gas
biogens1038963biogens
biogs85016113bio__gs
biologics1446863biologics
biolytic1546773biolytic_
biomass1155993biomass
biomes103815253bio_mes
biometrics1647193biometrics
bionomics1574583bionomics
bionts8612393bio_nts
biopsic1345523biopsic_
biopsies1237383biopsies
bios66335323bio___s
biota74516823biot__a
biotitic1247573biotitic
biotope1146623biotope
biotopes1246963biotopes
biotoxins1844183biotoxins
biotron937293biotron
biotrons1037233biotrons
biotype1444423biotype
biotypes1544683biotypes
biotypic1744403biotypic_
birdies104016213birdies
birkies133712433birkies
births115713603birt_hs
bisters93922603bisters
bistres94017213bistres
bistros92810983bistros
bitch125017763bi_t_ch
biters83925233bi_ters
bites75641173bi_t_es
biting95321823bi_ting
bits66148163bi_t__s
bitters94920353bitters
bittier94211663bittier
bittiest103012043bittiest
bitting103717293bitting
bittings11339293bittings
bittock1544433bittock
bittocks1644443bittocks
bitts75022593bi_t_ts
bivouacs1541803bivouacs
blocs95219653blo__cs
blotch13197143blot_ch
blots75626173blot__s
boccis123911133b_occis
bodice11711423b_odice
bodices12710593b_odices
bodies94524143b_odies
bogies94724313b_ogies
boils75427193b_o_ils
boites84322703boit_es
boobies113718203boobies
boodies103721443boodies
boogies103719013boogies
bookies133819403bookies
boonies93422483boonies
bootees94114473bootees
booths115313793boot_hs
bootie85421153booti_e
booting103821363booting
bootlick1664643bootlick
bootlicks17103903bootlicks
boots75837973boot__s
boric98024223b_oric_
botas75328783b_ot_as
botch126717453b_ot_ch
botels84815803b_otels
bothies12414783b_othies
bots66453953b_ot__s
botts75224863b_ot_ts
bovids1287973b_ovids
brionies10310543brionies
broils84114173bro_ils
bromic122412693bromic_
bromids12278603bromids
bromins112513783bromins
broncs101611153bro_ncs
broths115013923brot_hs
bucolics1443863bucolics
bustic101012693bustic_
butties93217953butties
cities84524853ci_ties
civics13397823ci_vics
clitics11279973clitics
colics104219903_colics
comics124015563_comics
conics103920593_conics
cooties93725733cooties
cretics112911653cretics
critics112811093critics
deictics1345563deictics
demotics1338753demotics
dhotis1038953dhoti_s
dioptrics1444093dioptrics
dioxids1655683dioxids
dioxins1568003dioxins
dirties83119383dirties
distich13312173distich
distichs1447633distichs
distils83015803distils
ditties83116983ditties
ebonics1137193ebonics
ekistics1485703ekistics
emetics11610723emetics
eristics10610193eristics
erotic82620263erotic_
erotica92811513erotica
exotic153112643exotic_
exotica16257603exotica
fifties132111083fifties
fistic11812573fistic_
footies103721543footies
frolics1236833frolics
fustics1279593fustics
gnostics1146313gnostics
gothics1336123_gothics
hidrotics1544513hidrotics
ictic9311803_ictic_
idiotic1037453idiotic_
intis55121643_inti_s
iodic84816753_iodic_
iodids83711153_iodids
iodins74216523_iodins
ionic74622663_ionic_
iotas54821113_iot_as
kilties113014143kilties
kinetics14207243kinetics
kitties113213623kitties
litotic939233litotic_
logics95711123_logics
lotic76420663_lotic_
luetics937323luetics
mastics112614783mastics
meiotic11410923meiotic_
mimics1289363mi_mics
miosis83615163miosi_s
mitis75425993mi_ti_s
mitotic1139703mitotic_
motifs1139673_motifs
myotic133112303myotic_
mystics14279103mystics
nicotins1058173nicotins
nifties102612503nifties
niobic1037243niobic_
notice8313443_notice
notices9312283_notices
ootids71110353_ootids
optics102810183_optics
otic66624813__otic_
ovonics12245553ovonics
peptics132610243peptics
phobics16286703phobics
phonics143110723phonics
photic133316423photic_
picnics13297343picnics
pieties9419223pieties
pionic103515953pionic_
pistils93314303pistils
pities83828083pi_ties
poetics11312073poetics
probiotics1644043probiotics
ptotic102713363ptotic_
quintics19266983quintics
rhotic112711213rhotic_
rioters73615503rioters
rioting82716393rioting
riotous739863riotous
riots54922013riot__s
robotics1245483robotics
rotis56327053_roti_s
rustics9810733rustics
sciatics12117273sciatics
scotias939733scotias
semiotics1376913semiotics
septics112810433septics
silvics1235563silvics
sixties14310973sixties
sonics84315633_sonics
statics93314533statics
stoics8311113sto_ics
stotins73213863stotins
tactics1149323tactics
tics65729633___tics
tictacs1145793tictacs
tictocs1145903tictocs
titis56023813ti_ti_s
titties73617363titties
tonics83617863_tonics
topics104714583_topics
torics85118353_torics
toxics153910203_toxics
tropics113610653tropics
ubieties1046913ubieties
viatic11311453viatic_
viatica1245863viatica
victims1436003victims
violins10311453violins
vitrics12198553vitrics
zitis145815583zi_ti_s
zloties1639913zloties

Search took 9 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 Limit1340272758.17316398.8
3Display Results2752750.0932957.0
 (SQL Overall)1786912758.42221217.2
 
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.