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 “biopsic” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

58 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
biopsic134552(None) 
biopic123710671biop_ic
bioptic1337561bioptic
bibasic1345642bibasic
bionic103614572bio_nic
biontic1148332biontic
biopics13318542biop_ics
biopsied1344592biopsied
biopsies1237382biopsies
biopsy1334532biops_y
biotic103816612bio_tic
abiosis939373abio_sis
abiotic11510463abio_tic
anopsia9258443anopsia
atopic103514143atop_ic
autopsic1246063autopsic
basic96220523b__asic
biochip1645323biochip
bioethic1544693bioethic
biogenic1347823biogenic
biogs85016113biogs__
biologic1348273biologic
biolysis1345363biolysis
biolytic1546773biolytic
bionics114310873bio_nics
bionomic1476153bionomic
biophysics2253493biophysics
biopsying1742453biopsying
bios66335323bio_s__
biotics113812173bio_tics
biotin83215833bio_tin
biotitic1247573biotitic
biotypic1744403biotypic
biphasic1744183biphasic
bishopric1852063bishopric
bops86037983b_ops__
boric98024223b_o_ric
bromic122412693bro_mic
diapsid1146703diapsid
dibasic1246033dibasic
diopside1245643diopside
diopsidic1552173diopsidic
dioptric1345623dioptric
dipodic1397593dipodic
iodic84816753_io_dic
ionic74622663_io_nic
kinesic13257023kinesic
miosis83615163mio_sis
miotic103715753mio_tic
myopic15308463myop_ic
niobic1037243nio_bic
opsin7613473__opsin
optic93715183__optic
pionic103515953pio_nic
popsie103013053_popsie
topic95721503_top_ic
trophic14311033trophic
tropic103014193trop_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 Filter1786911340270.390458182.1
2DLD Change Limit134027585.94022563.5
3Display Results58580.0163625.0
 (SQL Overall)178691586.34628158.1
 
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.