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

212 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
bitterer1030977(None) 
batterer102713211batterer
bittered112711831bittered
litterer82810171litterer
titterer8268521titterer
banterer102811772banterer
barterer102711632barterer
battener10369392battener
battered113315052battered
batterers113110712batterers
bettered113011832bettered
bickerer16106772bickerer
bistered112913322bistered
bitter84622672bitt__er
bitterest1147712bitterest
bitterly1335602bitterly
bittern94810682bitter_n
bitterns10428942bitterns
bitters94920352bitter_s
bittier94211662bitt_ier
buttered112712622buttered
butterier1177452butterier
ditherer12187762ditherer
fetterer11207812fetterer
filterer11258142filterer
fritterer12234402fritterer
jittered16267222jittered
jitterier1644432jitterier
letterer8259222letterer
littered92511382littered
litterers9228192litterers
miterer92511332mi_terer
mutterer10218912mutterer
patterer103112172patterer
potterer102310262potterer
putterer10209912putterer
tittered9239492tittered
titterers9236992titterers
totterer8217792totterer
twitterer1243302twitterer
utterer71910462_utterer
winterer112110442winterer
witherer14187952witherer
alterer72713993_alterer
austerer838383austerer
bantered113313633bantered
banterers112410003banterers
bartered113113013bartered
barterers11269633barterers
battened11259573battened
batteners11238163batteners
batter84928873batt__er
batterie10711533batterie
batteries11615113batteries
batters94626013batter_s
battery124911813batter_y
battier93515713batt_ier
battler94113383batt_ler
better84723703bett__er
betters94422093better_s
bickered17108003bickered
bickerers17115593bickerers
billeter1037563billeter
biometer1239603biometer
bioterror1152233bioterror
bister84922763bist__er
bisters93922603bister_s
bistre83815023bist_re_
bistred103311853bist_red
bistres94017213bist_res
bitchier15307733bitchier
biter75030033bi_t__er
biters83925233bi_ter_s
bitsier9379073bi_tsier
bitted94418483bitt__ed
bitten84715123bitt__en
bittering122511983bittering
bitterish1446133bitterish
bitterness1245553bitterness
bitternut1144323bitternut
bitterweed1642753bitterweed
blatherer14176713blatherer
blattered12198563blattered
blistered12167683blistered
blithered15156123blithered
blusterer11176293blusterer
bolsterer1145483bolsterer
borderer1168103borderer
bothered142110393bothered
bottler94211883bott_ler
bottomer1245103bottomer
brittler10165983britt_ler
butcherer1643753butcherer
butter84724233butt__er
butterbur1342923butterbur
butteries11711763butteries
butters94521713butter_s
buttery124311193butter_y
buttoner1036973buttoner
caterer92815933_caterer
chatterer14196843chatterer
chittered15166413chittered
cipherer1545573cipherer
cittern9339133citter_n
citterns10318113citterns
clatterer11186983clatterer
cottered112511733cottered
dithered13189293dithered
ditherers13196683ditherers
dotterel945063dotterel
embittered1542543embittered
enterer72015633_enterer
falterer11239853falterer
fattener11268113fattener
fettered12259493fettered
fetterers12267043fetterers
filtered12259043filtered
filterers12206973filterers
fingerer12127223fingerer
fitter94120033fitt__er
fitters104517743fitter_s
flatterer12187673flatterer
flittered13196253flittered
flutterer12185263flutterer
fosterer11239523fosterer
frittered13205163frittered
fritterers13203393fritterers
gatherer12147903gatherer
gettered10258613gettered
gittern8337503gitter_n
gitterns9326563gitterns
glittered11195403glittered
guttered10259153guttered
hinderer1238273hinderer
hitter94419863hitt__er
hitters104717583hitter_s
imbittered1542083imbittered
integer837993_integer
jitter133314993jitt__er
jitters144314463jitter_s
jittery17346443jitter_y
kipperer16294723kipperer
kittened1334523kittened
kittler11338163kitt_ler
latherer111310443latherer
lettered92910783lettered
letterers9228113letterers
limberer12187053limberer
lingerer9118303lingerer
listener8158313listener
litter64324853litt__er
litters73422563litter_s
littery103710493litter_y
littler7348553litt_ler
loiterer837083loiterer
mattered112412903mattered
mitered103213233mi_tered
miterers10219683mi_terers
mittened1136363mittened
muttered112610793muttered
mutterers11247373mutterers
nattered92011623nattered
nittier73512243nitt_ier
oysterer1136103oysterer
palterer102411273palterer
pattered112714203pattered
patterers112410123patterers
pesterer102412703pesterer
pewterer13256313pewterer
pilferer1344923pilferer
pottered112311663pottered
potterers11218653potterers
puttered112611143puttered
putterers11238363putterers
rattener8238533rattener
ritter63822413ritt__er
ritters74020613ritter_s
roisterer946433roisterer
rottener8216973rottener
scatterer11186293scatterer
shatterer12177203shatterer
silverer11216733silverer
simperer1237173simperer
sincerer1037203sincerer
sintered92213903sintered
sistered92612803sistered
sitter63323383sitt__er
sitters74221543sitter_s
skittered1434633skittered
skitterier1442423skitterier
smatterer11185813smatterer
sputterer11165263sputterer
steerer73113633_steerer
stutterer9164913stutterer
tattered92011443tattered
tinkerer1286803tinkerer
titter63421163titt__er
titters74219613titter_s
tottered9208703tottered
totterers9186813totterers
twittered1333813twittered
twitterers1342673twitterers
uttered82712433_uttered
utterers8218653_utterers
waterer103314073_waterer
wintered122111573wintered
winterers12209723winterers
winterier1238333winterier
withered15169433withered
witherers15146843witherers
wittier103910823witt_ier
yattered12239533yattered

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461622129.47015434.2
3Display Results2122120.0802650.0
 (SQL Overall)1786912129.72018383.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.