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

168 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
biopics1331854(None) 
bionics114310871bionics
biopic123710671biopic_
biotics113812171biotics
bionic103614572bionic_
biopsic1345522biopsic_
biopsies1237382biopsies
bioptic1337562bioptic_
biotic103816612biotic_
biotins93114452biotins
ionics84214482_ionics
miotics112710652miotics
topics104714582_topics
tropics113610652tropics
abiosis939373abiosi_s
abiotic11510463abiotic_
aiolis6316843aioli_s
anopias92412483anopias
aspics104211563_aspics
atomics113110853atomics
atonics93613713atonics
atopic103514143atopic_
atopies92816433atopies
avionics1344953avionics
basics104915123b_asics
beylics1436183beylics
bialies93618413bialies
bialis83617163biali_s
biddies113514493biddies
bidis86721143bi_di_s
biffies152710853biffies
biffins15358533biffins
biggies113813523biggies
biggins113410693biggins
bigwigs1443003bigwigs
bikies124515163bi_kies
bilbies114712343bilbies
billies93923503billies
bindis94614583bindi_s
binits85716673bi_nits
binocs1039923bi_nocs
biochips1744843biochips
biocide1237323biocide
biocides1336933biocides
bioethics1643843bioethics
biofilm1444333biofilm
biofilms1542773biofilms
biogas94310913bio_gas
biogens1038963biogens
biogs85016113bio__gs
biologics1446863biologics
biomass1155993biomass
biomes103815253bio_mes
bionomics1574583bionomics
biontic1148333biontic_
bionts8612393bio_nts
biophysics2253493biophysics
biopiracy1851573biopiracy
bioplasm1444873bioplasm
biopsied1344593biopsied
biopsy1334533biop_sy
bios66335323bio___s
biotas84313923bio_tas
biotech14104493biotech
biotechs15123853biotechs
biotical1248863biotical
biotin83215833bioti_n
biotite9311033biotite
biotites10310083biotites
biotypic1744403biotypic_
bipack1636523bi_pack
bipacks1745043bi_packs
bipeds11458053bi_peds
bipods11408593bi_pods
birdies104016213birdies
birkies133712433birkies
bishoprics1951483bishoprics
bivouacs1541803bivouacs
blocs95219653blo__cs
boccis123911133b_occis
bodice11711423b_odice
bodices12710593b_odices
bodies94524143b_odies
bogies94724313b_ogies
boils75427193b_o_ils
boobies113718203boobies
boodies103721443boodies
boogies103719013boogies
bookies133819403bookies
boonies93422483boonies
booties94124613booties
bops86037983b_op__s
boric98024223b_oric_
bovids1287973b_ovids
brionies10310543brionies
broils84114173bro_ils
bromic122412693bromic_
bromids12278603bromids
bromins112513783bromins
broncs101611153bro_ncs
bucolics1443863bucolics
buppies133011063buppies
bustics11810883bustics
chopins142312243chopins
civics13397823ci_vics
colics104219903_colics
comics124015563_comics
conics103920593_conics
copies104130303_copies
diapirs10347643diapirs
dioptrics1444093dioptrics
dioxids1655683dioxids
dioxins1568003dioxins
ebonics1137193ebonics
epics95014283__epics
erotics91914153erotics
exotics16229193exotics
frolics1236833frolics
hippies142813753hippies
impis96213853_impi_s
iodic84816753_iodic_
iodids83711153_iodids
iodins74216523_iodins
ionic74622663_ionic_
lipids94310923li_pids
lipins85016883li_pins
lipoids1038233lipoids
logics95711123_logics
mimics1289363mi_mics
miosis83615163miosi_s
miotic103715753miotic_
myopias14308153myopias
myopic15308463myopic_
myopies14309723myopies
myotics14257603myotics
niobic1037243niobic_
nitpick1543783nitpick
nitpicks1643183nitpicks
optics102810183__optics
ovonics12245553ovonics
phobics16286703phobics
phonics143110723phonics
photics142810483photics
picnics13297343picnics
pics85633913___pics
pionic103515953pionic_
pipits104713063pi_pits
pippins10319753pippins
silvics1235563silvics
sinopias1047873sinopias
sonics84315633_sonics
spics94123243__spics
stoics8311113sto_ics
subtopics1543733subtopics
tiepins939463tiepins
tipis76019923ti_pi_s
tonics83617863_tonics
topic95721503_topic_
topis76025833_topi_s
torics85118353_torics
toxics153910203_toxics
tropic103014193tropic_
tropins93116313tropins
utopias9117723utopias
violins10311453violins
vitrics12198553vitrics
wicopies1545983wicopies
yippies14279293yippies

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.403443402.0
2DLD Change Limit1340271686.75319847.0
3Display Results1681680.0632666.7
 (SQL Overall)1786911687.21924752.9
 
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.