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

97 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
biotech1410449(None) 
biotechs15123851biotechs
biotic103816612biotic_
biotics113812172biotics
bitch125017762bi_t_ch
blotch13197142blot_ch
botch126717452b_ot_ch
abiotic11510463abiotic_
aitch105216163ai_t_ch
batch124620103b_at_ch
beech124315503b__eech
beseech1453873beseech
bigoted11258403bigote_d
biogen9310253bioge_n
biogens1038963biogens
biogeny1336023biogeny
bioherm1434653bioherm
biome94916993biome__
biomes103815253biome_s
bionic103614573bionic_
bionics114310873bionics
biontic1148333biontic_
biopic123710673biopic_
biopics13318543biopics
bioptic1337563bioptic_
biota74516823biot__a
biotas84313923biot_as
biotical1248863biotical
biotin83215833biot_in
biotins93114453biotins
biotite9311033biotite
biotope1146623biotope
biotron937293biotron
biotype1444423biotype
birch124914023bi__rch
birrotch1542393birrot_ch
birth105619873birt__h
bisect10312873bi_sect
bister84922763biste_r
bisters93922613bisters
bitchy16479203bi_t_chy
bite66547003bi_te__
biter75030033bi_te_r
biters83925243bi_ters
bites75641173bi_te_s
bitted94418483bitte_d
bitten84715123bitte_n
bitter84622673bitte_r
bittern94810683bittern
bitters94920363bitters
bittock1544433bittock
blotchy17293973blot_chy
bobeche1643843b_obeche
boite74426323boite__
boites84322703boite_s
booted94822733boote_d
bootee84323023boote_e
bootees94114473bootees
bootery1238983bootery
booth105522013boot__h
borsch1336133b_orsch
botchy16537823b_ot_chy
botel75121863b_ote_l
botels84815803b_otels
both96533433b_ot__h
breech13348263b_reech
broach133611113bro_ach
brooch13368443bro_och
broth106521093brot__h
butch125416543b_ut_ch
crotch133410083crot_ch
dioecy1235543dio_ecy
diptych1842613diptych
distich13312173distich
ditch115015093di_t_ch
fitch134816873fi_t_ch
hitch134515473hi_t_ch
hootch14386413hoot_ch
hotch136214733_hot_ch
isotach1244953isotach
itch95619173_i_t_ch
kitsch1533353ki_tsch
miotic103715753miotic_
miotics112710653miotics
misteach1545443misteach
nanotech1341973nanotech
notch105613323_not_ch
pitch125018413pi_t_ch
protect11313633protect
rioted73416373riote_d
rioter64817283riote_r
rioters73615513rioters
rotch105815933_rot_ch
scotch13207523scot_ch
tech95925443___tech
witch134517563wi_t_ch
zlotych2441413zlotych

Search took 6 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 Limit134027975.76623244.4
3Display Results97970.0303233.3
 (SQL Overall)178691975.95230022.0
 
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.