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

210 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
blistery1341871(None) 
blister94415311blister_
blisters104015081blisters
blustery13368001blustery
bister84922762b_ister_
bisters93922612b_isters
blaster94017302blaster_
blasters104116142blasters
blistered12167682blistered
bluster94215312bluster_
blusters104413892blusters
clustery13317112clustery
glister84013342glister_
glisters93912602glisters
glittery12375612glittery
klister113410642klister_
klisters123910482klisters
lister64527252_lister_
listers74026532_listers
littery103710492_littery
plastery13279702plastery
allostery1243723allostery
baiter84422553bai_ter_
baiters94619303bai_ters
baluster1037053baluster_
balusters1136643balusters
banister10199973banister_
banisters11189473banisters
baptistery1742173baptistery
baster85333593b_aster_
basters94930303b_asters
battery124911813b_attery
bibbery13426543b_ibbery
bilsted1038033bilste_d
bilsteds1134273bilsteds
bindery13459833b_indery
bistered112913323b_istered
bistort91216523b_istort
bistoury1343413b_istoury
bistre83815023b_ist_re
bistred103311853b_istred
bistres94017213b_istres
bistro8339943b_ist_ro
biter75030033b_i_ter_
biters83925243b_i_ters
bitter84622673b_itter_
bitterly1335603b_itterly
bittern94810683b_ittern
bitters94920363b_itters
bladdery15344583bladdery
blasted104213473blaste_d
blastema1244683blastema
blastier10249493blastier_
blasty115611053blast__y
blatter94415653blatter_
blatters104414093blatters
bleater94515303bleater_
bleaters103412323bleaters
blesser9329293blesser_
blessers10277633blessers
blighter1466853blighter_
blighters1555743blighters
blimey13468453bli_me_y
blinder103912983blinder_
blinders113911143blinders
blinker134110213blinker_
blinkers14388503blinkers
blissed10388373blisse_d
blisses94911513blisse_s
blistering13107063blistering
blite76225353bli_te__
blites84721213bli_te_s
blithely16104033blithely
blither124812173blither_
blithers134711233blithers
blitzer18447663blitzer_
blitzers19417153blitzers
bloater94013423bloater_
bloaters103311023bloaters
bloomery15335693bloomery
blotter94612853blotter_
blotters104110983blotters
blubbery14294783blubbery
blunter94512033blunter_
blurter9419833blurter_
blurters10348373blurters
blusher124113113blusher_
blushers133911293blushers
blustered12157263blustered
blusterer11176293blusterer
boaster94616433boaster_
boasters103915663boasters
bolster93713423bolster_
bolsters103712453bolsters
booster94314553booster_
boosters104013443boosters
bootery1238983b_ootery
bribery14426493bri_bery
briery114510773bri__ery
brisker134210293brisker_
bristly12178063brist_ly
burster9310293burster_
bursters1038983bursters
buster84726493b_uster_
busters94724133b_usters
buttery124311193b_uttery
cistern93310703_cistern
clattery13378193clattery
cloister1037093cloister_
cloisters1137433cloisters
cluster94013333cluster_
clusters102912403clusters
cluttery13346323cluttery
clyster12317453clyster_
clysters13227843clysters
enlister847803enlister_
enlisters937113enlisters
filister1137403filister_
filisters1237003filisters
fishery16397733_fishery
flattery14338293flattery
flickery20365103flickery
flirter10318673flirter_
flirters11337933flirters
flitter103413903flitter_
flitters114312173flitters
fluster103913063fluster_
flusters113811503flusters
fluttery14376143fluttery
glisten8418083gliste_n
glistens9366593glistens
glistered11176293glistered
glitter84211803glitter_
glitters93710543glitters
grister83915413grister_
gristers94013403gristers
heister103613623heister_
heisters113413133heisters
history1339423_history
hoister103714203hoister_
hoisters113513483hoisters
jittery17346443_jittery
keister113011573keister_
keisters123212043keisters
laster64830633_laster_
lasters75627693_lasters
leister73212753leister_
leisters83312823leisters
lientery1134883_lientery
lifter93814813_lifter_
lifters104313783_lifters
linter64625343_linter_
linters73822633_linters
lisper84114433_lisper_
lispers94514323_lispers
listed74322833_liste_d
listee64223063_liste_e
listees73416673_listees
listel64214743_liste_l
listels74212433_listels
listen64816813_liste_n
listens74014133_listens
listeria839433_listeria
liter54736343_li_ter_
liters65429883_li_ters
litter64324853_litter_
litters73422573_litters
livery124910903_li_very
lottery10389833_lottery
luster64023673_luster_
lusters73921443_lusters
mastery124214323_mastery
meister93114163meister_
meisters103313843meisters
misery114113543_mis_ery
mister84728563_mister_
misterm114314513_misterm
misters93927513_misters
moister94015373moister_
mystery15436523_mystery
nitery94412173_ni_tery
oldster896573oldster_
oldsters996733oldsters
plaister1068013plaister_
plaisters1137813plaisters
plaster93318693plaster_
plasters103518133plasters
printery13318433printery
roister73516203roister_
roisters83615553roisters
sister64421583_sister_
sisterly1146333_sisterly
sisters73721593_sisters
skittery15315103skittery
slippery15275863slippery
slithery14356703slithery
slitter73615873slitter_
slitters84014133slitters
splintery14264793splintery
twister10308953twister_
twisters11268173twisters
twittery14303893twittery
ulster63712103ul_ster_
ulsters72711983ul_sters
waister103812383waister_
waisters113811523waisters
wastery134610993_wastery
whiskery21314553whiskery
whispery19284293whispery
wintery13399753_wintery

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.436409841.7
2DLD Change Limit1461622106.90621164.5
3Display Results2102100.0802625.0
 (SQL Overall)1786912107.42224075.9
 
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.