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

91 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
biotopes124696(None) 
biotope1146621biotope_
biotypes1544681biotypes
bioscopes1546552bioscopes
biotites10310092biotites
biotype1444422biotype_
isotopes10228072isotopes
apocopes1445993apocopes
bigoses1039073bi_goses
bigotries1286443bigotries
bilboes114410243bilbo_es
biltongs1133813biltongs
bimboes13498733bimbo_es
bingoes104013983bingo_es
biocides1336943biocides
biogases1136143biogases
biologies12311183biologies
biolyses1345573biolyses
biomes103815253bi__omes
biomorphs1844193biomorphs
bionomies1397153bionomies
biopsies1237403biopsies
bioscope1446483bioscope_
bioscopies1645383bioscopies
biostromes1444043biostromes
biotas84313923biot__as
biotechs15123853biotechs
biotics113812173biot_ics
biotins93114453biot_ins
biotite9311033biotite_
biotoxin1744273biotoxin
biotoxins1844183biotoxins
biotrons1037243biotrons
biotypic1744403biotypic
bishoped1644663bishoped
bishops1437033bishop_s
bistorts10118813bistorts
bistres94017213bist_res
bitches144117063bi_tches
bites75641173bi_t__es
bittocks1644443bittocks
bizones1837823bi_zones
blooped12398543blo_oped
blooper11358533blo_oper
bloopers12397373blo_opers
bloops106611343blo_op_s
blotches1537433blotches
boites84322703boit__es
boltropes1344063boltropes
bootees94114473boot_ees
booties94124613boot_ies
boozes174916523b_o_ozes
botches143716023b_otches
bothies12414783b_othies
botonee9311833b_otonee
bottles94216273b_ottles
citoles9312553ci_toles
cotypes1437943_cotypes
distomes11314163distomes
duotones937643duotones
ecotones1039493ecotones
ecotypes1545053ecotypes
epitopes1246973epitopes
footropes1446413footropes
histones11312803histones
idiotypes1542973idiotypes
intones7816543_intones
ionones7313883_ionones
isotones82210433isotones
isotope9227783isotope_
isotopies11207353isotopies
isotypes13234853isotypes
linotypes1444063linotypes
liriopes1043893liriopes
litotes7311183li_totes
lotoses73713653_lotoses
metopes11311363_metopes
mistypes15116713mistypes
mitoses9312183mi_toses
myotomes1546233myotomes
neotypes1344523neotypes
pintoes95117713pinto_es
pistoles102514723pistoles
riotous739873rioto_us
stopes84525893__stopes
tintypes1343273tintypes
tiptoes939173tipto_es
tiptops1136073tiptop_s
topes76941763___topes
viatores11257693viatores
violones1137383violones

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 Filter1786911461620.420425454.8
2DLD Change Limit146162916.76621602.4
3Display Results91910.0303033.3
 (SQL Overall)178691917.21624763.2
 
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.