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

82 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
biotope114662(None) 
biotopes1246961biotopes
biotype1444421biotype
bioscope1446482bioscope
biotite9311032biotite
biotypes1544682biotypes
isotope9227782isotope
apocope1346033apocope
bigtime1235753bigtime
biltong1034683biltong
biocide1237323biocide
biology1337363biology
biome94916993bi__ome
biomorph1743893biomorph
bionomy1444723bionomy
bioscopes1546553bioscopes
bioscopy1743823bioscopy
biostrome1344613biostrome
biota74516823biot__a
biotas84313923biot_as
biotech14104493biotech
biotic103816613biot_ic
biotics113812173biotics
biotin83215833biot_in
biotins93114453biotins
biotites10310093biotites
biotoxin1744273biotoxin
biotron937293biotron
biotrons1037243biotrons
biotypic1744403biotypic
bishop1336943bishop_
bishoped1644663bishoped
bishops1437033bishops
bistate9313823bistate
bistort91216523bistort
bistre83815023bist_re
bite66547013bi_t__e
bittock1544433bittock
bizone1738603bi_zone
blooie83913193blo_oie
bloop96116153blo_op_
blooped12398543blo_oped
blooper11358533blo_oper
bloops106611343blo_ops
boite74426323boit__e
boltrope1243903boltrope
bootee84323023boot_ee
bootie85421163boot_ie
booze164718913b_o_oze
botonee9311833b_otonee
bottle84916073b_ottle
citole8311503ci_tole
cotype1346823_cotype
distome10313233distome
duotone836893duotone
ecotone938583ecotone
ecotype1444843ecotype
epitope1147053epitope
footrope1346253footrope
histone10312843histone
idiotype1442963idiotype
intone61115433_intone
ionone6313443_ionone
isotone7239983isotone
isotopes10228073isotopes
isotopy12215123isotopy
isotype12224953isotype
linotype1343963linotype
liriope944043liriope
metope10611123_metope
mistype14126523mistype
myotome1445483myotome
neotype1244593neotype
pistole92414313pistole
riotous739873riotous
stope74727243__stope
tintype1243033tintype
tiptoe838283tipto_e
tiptop1036103tiptop_
tiptops1136073tiptops
tope65946383___tope
violone1037153violone

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.406440125.6
2DLD Change Limit134027825.92322628.2
3Display Results82820.0302733.3
 (SQL Overall)178691826.35928100.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.