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

136 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
bioherm143465(None) 
bioherms1544211bioherms
basher115123813basher_
bashers124820833bashers
bather115322513bather_
bathers124720363bathers
becharm1636843becharm
berm86732753b___erm
bibber94613573bibber_
bibbers103911353bibbers
bibbery13426543bibbery
bicker144819173bicker_
bickers154316553bickers
bidder104114863bidder_
bidders114012313bidders
bider85728373bi_der_
biders94822803bi_ders
bier65531833bi__er_
biers76225223bi__ers
biform1368123bi_form
bigger104315063bigger_
bighead14126653bighead
bighorn1346063bighorn
biker116022563bi_ker_
bikers124517553bi_kers
bilker124913443bilker_
bilkers134711863bilkers
biller84923483biller_
billers94720833billers
binder94422873binder_
binders103920743binders
bindery13459833bindery
biner75930693bi_ner_
biners85023633bi_ners
binger94923453binger_
bingers104519993bingers
biofilm1444333biofilm
biogen9310253bioge_n
biogens1038963biogens
biogeny1336023biogeny
biome94916993biome__
biomes103815253biome_s
biometry1546183biometry
biosphere1664783biosphere
biotech14104493biotech
birder94915493birder_
birders103913263birders
birler85715083birler_
birlers93813003birlers
bister84922763bister_
bisters93922613bisters
bitchery18236563bitchery
biter75030033bi_ter_
biters83925243bi_ters
bitter84622673bitter_
bittern94810683bittern
bitters94920363bitters
blither124812173blither_
blithers134711233blithers
blower115316573blower_
blowers124313593blowers
bohea105013733b_ohe_a
boheas114013213b_oheas
boiler84319273boiler_
boilers93417063boilers
bolero8412093b_olero
boner75133083b_oner_
boners84825433b_oners
booger94816553booger_
boogers104514633boogers
booker124719193booker_
bookers134016613bookers
boomer104618513boomer_
boomers114115913boomers
bootery1238983bootery
boozer174815963boozer_
boozers183912443boozers
borer75131273b_orer_
borers85122683b_orers
bother115218063bother_
bothers124317753bothers
bower107328183b_ower_
bowers115523703b_owers
bowery146012113b_owery
boxer145016523b_oxer_
boxers155013483b_oxers
broker124314243broker_
brokers133111913brokers
brother123311333brother_
brothers133410833brothers
busher114922203busher_
bushers124018803bushers
cipher133710263cipher_
ciphers14379993ciphers
cither114616683cither_
cithern12489913cithern
cithers124315773cithers
cohere112716993_cohere
dishelm1335833dishelm
dither104417683dither_
dithers114016153dithers
dithery14318943dithery
either94517423either_
exoderm1754893exoderm
fisher124917143fisher_
fishers134714723fishers
fishery16397733fishery
herm95636153___herm
higher134610893higher_
hither124417253hither_
inhere9313713_inhere
isotherm1344283isotherm
ither84617603_ither_
lither94520953lither_
midterm12316013midterm
misterm114314513misterm
mither114218563mither_
mithers123516733mithers
nigher103612753nigher_
pisher114317753pisher_
pishers123815753pishers
richer114015043richer_
rioter64817283rioter_
rioters73615513rioters
sigher103813703sigher_
sighers113712183sighers
therm106018023__therm
tither94920283tither_
tithers104216733tithers
wisher123617063wisher_
wishers133215213wishers
wither124321353wither_
withers134417753withers
zither183813083zither_
zithern19447023zithern
zithers193911973zithers

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271366.53320515.4
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.00225520.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.