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

261 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
bitterns1042895(None) 
bittern94810681bittern_
bitters94920361bitter_s
citterns10318121citterns
gitterns9326571gitterns
battens95313262batte_ns
batters94626012batter_s
betters94422092better_s
bisters93922612bister_s
biters83925242bi_ter_s
bitten84715122bitte_n_
bitter84622672bitter__
bittered112711832bittered
bitterer10309772bitterer
bitterest1147712bitterest
bittering122511992bittering
bitterish1446132bitterish
bitterly1335602bitterly
bitterness1245552bitterness
bitternut1144322bitternut
bitternuts1242722bitternuts
butters94521722butter_s
cisterns10369572cisterns
citherns13338872citherns
cittern9339142cittern_
fitters104517752fitter_s
gittern8337502gittern_
hitters104717592hitter_s
interns73116772_interns
jitters144314472jitter_s
kittens11347582kitte_ns
litters73422572litter_s
mittens9349882mitte_ns
patterns10439942patterns
ritters74020622ritter_s
sitters74221552sitter_s
titters74219622titter_s
zitherns20376132zitherns
abetters1057173abetter_s
abutters1056993abutter_s
attorns738443_attorns
bacterins13410643bacterins
baiters94619303baiter_s
banters94623113banter_s
barters94223033barter_s
basters94930303baster_s
bathers124720363bather_s
batten85217123batte_n_
batter84928873batter__
battered113315053battered
batterer102713213batterer
batterers113110713batterers
batterie10711533batterie
batteries11615113batteries
battering122715143battering
battery124911813batter_y
battlers104110973battler_s
beaters94925043beater_s
belters93819413belter_s
bethorns1337323bethorns
better84723703better__
bettered113011833bettered
bettering122212753bettering
bettors93312473bettor_s
bibbers103911353bibber_s
bickers154316553bicker_s
bicorns11338763bi_corns
bidders114012313bidder_s
biders94822803bi_der_s
biers76225223bi__er_s
bighorns1445253bighorns
bikers124517553bi_ker_s
bilkers134711863bilker_s
billers94720833biller_s
binders103920743binder_s
biners85023633bi_ner_s
bingers104519993binger_s
biogens1038963bioge_ns
bioherms1544213bioherms
biotechs15123853biotechs
biotins93114453biot_ins
biotrons1037233biotrons
birders103913263birder_s
birlers93813003birler_s
bister84922763bister__
bistered112913323bistered
bistorts10118813bistorts
bistres94017213bist_res
bistros92810983bist_ros
biter75030033bi_ter__
bites75641173bi_te__s
bitted94418483bitte__d
bittier94211663bittier__
bitting103717293bitt_ing
bittings11339293bittings
bittocks1644443bittocks
bitts75022593bitt___s
bitumens1243523bitumens
blatters104414093blatter_s
blisters104015083blister_s
blithers134711233blither_s
blitzers19417153blitzer_s
blotters104110983blotter_s
boaters93419243boater_s
bolters94017803bolter_s
bothers124317753bother_s
bottlers103810013bottler_s
bunters94717123bunter_s
busters94724133buster_s
butlers94518053butler_s
butter84724233butter__
buttered112712623buttered
butteries11711763butteries
buttering122312523buttering
butternut1144743butternut
butternuts1242983butternuts
buttery124311193butter_y
buttes84822563butte__s
buttons9310333butt_ons
buttress1035883buttress
chitters133711173chitter_s
cistern93310703cistern_
cisterna10376363cisterna
citers85022983ci_ter_s
cithern12489913cithern_
cithers124315773cither_s
cithrens13355933cithrens
cotters94323443cotter_s
critters103511323critter_s
cutters94218963cutter_s
dieters83216433dieter_s
dipterans1245723dipterans
discerns1138163discerns
dithers114016153dither_s
dotters83715973dotter_s
embitters13334723embitter_s
emitters10349643emitter_s
externs1438233_externs
fattens105111713fatte_ns
fetters103517903fetter_s
fifteens1442753fifteens
filters103816553filter_s
fitter94120033fitter__
flitters114312173flitter_s
fritters113810783fritter_s
getters84216103getter_s
glitters93710543glitter_s
gritters94210633gritter_s
gutters83715513gutter_s
hatters104221523hatter_s
hinters103719583hinter_s
hitter94419863hitter__
icterus936073_icterus
imbitters13274503imbitter_s
intern64016543_intern_
interne73218143_interne
internes82721233_internes
inters64328053_inter_s
inturns73210133_inturns
jilters144211963jilter_s
jitter133314993jitter__
jittered16267223jittered
jittering17218423jittering
jittery17346443jitter_y
jotters143413803jotter_s
kilters113813603kilter_s
kiters105218593ki_ter_s
kitten104611483kitte_n_
knitters12336623knitter_s
lanterns838303lanterns
lattens75014673latte_ns
lecterns1035943lecterns
letters73819853letter_s
lifters104313783lifter_s
linters73822633linter_s
listens74014133liste_ns
listers74026533lister_s
liters65429883li_ter_s
litten64014873litte_n_
litter64324853litter__
littered92511383littered
litterer82810173litterer
litterers9228193litterers
littering102411983littering
littery103710493litter_y
lotters73921063lotter_s
lutherns1136293lutherns
matters94421753matter_s
midterms13284863midterms
milters93619093milter_s
minters93822473minter_s
misterms123711353misterms
misters93927513mister_s
miters84328783mi_ter_s
mithers123516733mither_s
mitten83914093mitte_n_
mutters94117143mutter_s
natters73718063natter_s
netters73618583netter_s
niters64624213ni_ter_s
nutters74215433nutter_s
omitters10277653omitter_s
otters64021513_otter_s
outturns835913outturns
pasterns104112623pasterns
pattens95414923patte_ns
pattern93712053pattern_
patters94825193patter_s
petters93722363petter_s
pitiers93812653pitier_s
posterns102713723posterns
potteens10256793potteens
potters94024343potter_s
putters94219193putter_s
quitters17238523quitter_s
ratteens8256053ratteens
rattens74213403ratte_ns
ratters74422473ratter_s
rioters73615513rioter_s
ritter63822423ritter__
rotters74421393rotter_s
salterns8388903salterns
setters73822063setter_s
sifters103714793sifter_s
sinters74024083sinter_s
sisters73721593sister_s
sithens1039383sithe_ns
sitten64113823sitte_n_
sitter63323383sitter__
sixteens1542943sixteens
skitters12349553skitter_s
slatterns935363slatterns
slitters84014133slitter_s
spitters104113383spitter_s
sterns64616763__sterns
tatters74520483tatter_s
terns55226873___terns
tetters74320473tetter_s
tilters73315953tilter_s
tinters74221113tinter_s
titers64526413ti_ter_s
titfers10318933titfer_s
tithers104216733tither_s
titter63421163titter__
tittered9239493tittered
titterer8268523titterer
titterers9236993titterers
tittering102310313tittering
totters74618733totter_s
twitters11296773twitter_s
utters63817123_utter_s
vetters104016323vetter_s
westerns11328963westerns
wetters103817753wetter_s
whitters14359403whitter_s
winters103720483winter_s
withers134417753wither_s
wiverns13366963wi_verns
yatters103914623yatter_s
zithern19447023zithern_
zithers193911973zither_s

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.406440125.6
2DLD Change Limit1461622617.11020557.2
3Display Results2612610.0932806.5
 (SQL Overall)1786912617.60923484.2
 
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.