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

126 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
biomass115599(None) 
bimahs13508302bi_mahs
bimas95521742bi_ma_s
biogas94310912bioga_s
biogases1136142biogases
biomasses1343962biomasses
biomes103815252biom_es
biotas84313922biota_s
bitmaps1344252bitmaps
bromals1139742bromals
abomas101113583aboma_s
abomasa11114613abomasa
abomasi11115493abomasi
abomasus1242853abomasus
admass957143_admass
amass77119683__amass
aromas81018613aroma_s
badass949293b_adass
bagass938933b_agass
baobabs1044443baobabs
bass66146783b___ass
bemas96424283b_ema_s
bemoans1138253bemoans
bias64738163bi__a_s
biases84618433bi__ases
bibless11439173bibless
bifocals1543703bifocals
bigness1038193bigness
bima86723833bi_ma__
bimah127013273bi_ma_h
bimbos124610523bi_mbos
binomials1343903binomials
bioassay1342653bio_assay
biogasses1244003biogasses
biogens1038963biogens
biogs85016113bio__gs
biolyses1345573biolyses
biolysis1345363biolysis
biome94916993biom__e
bionics114310873bionics
bionts8612393bio_nts
biopics13318543biopics
bioplasm1444873bioplasm
bioplasms1544383bioplasms
biopsy1334533bio_psy
bios66335323bio___s
biota74516823biota__
biotics113812173biotics
biotins93114453biotins
bitmap1235613bitma_p
bivouacs1541803bivouacs
bloats85215763blo_ats
boars75229603b_o_ars
boas66150833b_o_a_s
boast75935703b_o_ast
boasts85017923b_o_asts
boats75635153b_o_ats
bogans95714813b_ogans
bolas74733763b_ola_s
bolases93315003b_olases
bombast1348223b_ombast
bombasts1444953b_ombasts
bombes124916823b_ombes
bombs115818823b_om_bs
boomers114115913boomers
booms95427123boom__s
borals86721913b_orals
boras75938303b_ora_s
boss65938343b_o__ss
botas75328783b_ota_s
boyars115611983b_oyars
brass75428023b__rass
broads94515153bro_ads
brogans1049663brogans
bromal10313653broma_l
bromate11313553bromate
bromates12413143bromates
bromes104719763brom_es
bromids12278603bromids
bromins112513783bromins
bromism1337623bromism
bromisms1436403bromisms
bromos104213313brom_os
bypass1345043b_ypass
camass104114183_camass
comas95833003_coma_s
compass13379563_compass
dioxans1555313dioxans
dismals102010243dismals
dismast10311233dismast
dismasts1137513dismasts
dismays13237433dismays
dismiss1038153dismiss
firmans12238523firmans
gimmals12225823gimmals
gliomas1035333glioma_s
imams91511113_i_mams
iotas54821113_iota_s
jiveass1792163jiveass
kirmess13234313kirmess
kismats13257843kismats
limans84816303li_mans
limas75627633li_ma_s
lioness739103lioness
lipomas1156443lipoma_s
mass66044943___mass
mimosas1136753mimosas
morass84614503_morass
myomas1338303myoma_s
nomads94711603_nomads
nomas74726413_noma_s
omasa749483__omasa
pimas94725103pi_ma_s
pitmans11188743pitmans
riojas1335813rioja_s
romans84620243_romans
sigmas94111363sigma_s
simars84916933si_mars
simas75727553si_ma_s
somans84619303_somans
somas76030373_soma_s
stomas84816323stoma_s
tomans85419133_tomans
violas93713523viola_s
wiseass1035823wiseass
womans114613653_womans

Search took 10 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.826216332.9
2DLD Change Limit1340271268.17316398.8
3Display Results1261260.0462739.1
 (SQL Overall)1786911269.04519755.8
 
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.