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

436 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
holsters11321194(None) 
bolsters103712451bolsters
hoisters113513481hoisters
holster103512211holster_
boasters103915662boasters
bolster93713422bolster_
bolters94017802bol_ters
boosters104013442boosters
coasters104317332coasters
colters93522442col_ters
costers94128332co_sters
fosters104220102fo_sters
halters104619802hal_ters
hamsters13710422hamsters
heisters113413132heisters
hipsters13268792hipsters
hoister103714202hoister_
holders113715902hol_ders
hollers103818232hol_lers
holstein1145002holstein
holsteins1245262holsteins
holstered1345882holstered
hoopsters1445692hoopsters
hooters104520472ho_oters
horstes104516112horste_s
hosers95223962ho_s_ers
hosiers104212642ho_siers
hostels103712312ho_stels
hostess103210242ho_stess
hostlers113310482ho_stlers
housers104717812hous_ers
jolters143711992jol_ters
jousters153210422jousters
lobsters10268742lobsters
mobsters12359062mobsters
molesters1198872molesters
molters93816972mol_ters
monsters103314552monsters
oldsters996732_oldsters
ousters74122792_ousters
oysters103411692_oysters
pollsters1137172pollsters
posters93928012po_sters
roasters83615932roasters
roisters83615552roisters
roosters83514662roosters
rosters73727542ro_sters
rousters84315682rousters
roysters113610532roysters
toasters83912722toasters
ulsters72711982_ulsters
upholsters1542732upholsters
zosters163015412zo_sters
alters64924223_al_ters
asters65631603__asters
balusters1136643balusters
basters94930303_basters
belters93819413bel_ters
bilsteds1134273bilsteds
bisters93922613_bisters
blasters104116143blasters
blisters104015083blisters
bloaters103311023bloaters
blotters104110983blotters
blusters104413893blusters
boaster94616433boaster_
boaters93419243bo_aters
boletes9316063bolete_s
bolstered1246093bolstered
bolsterer1145483bolsterer
bolsterers1244683bolsterers
bolter83920753bol_ter_
booster94314553booster_
bursters1038983bursters
busters94724133_busters
casters94729903_casters
cholates132414763cholate_s
cholers124215203chol__ers
choosers134810873choos_ers
choristers1586103choristers
chousers134610203chous_ers
cloisters1137433cloisters
closers94415323clos_ers
clouters10399803clouters
clusters102912403clusters
clysters13227843clysters
coaster94219043coaster_
coaters93525793co_aters
cointers103616413cointers
colliers103613583colliers
colorers10312183colorers
colter84625093col_ter_
cooters94525723co_oters
copters113621283co_pters
coshers123618183co_shers
costars94218013co_stars
coster84331293co_ster_
cotters94323443co_tters
coulters103614313coulters
counters103320193counters
courters103015373courters
couters93827303co_uters
coveters132411083coveters
dabsters1137053dabsters
delusters1035983delusters
diasters92913183diasters
diesters92513603diesters
dilaters92513063dilaters
diluters9288113diluters
doomsters1236173doomsters
dopesters1237283dopesters
dorsers83516303dors_ers
dosers75723633do_s_ers
dossers84516233do_ssers
dossiers9318043dossiers
doters74423913do__ters
dotters83715973do_tters
doubters11257393doubters
dousers84817273dous_ers
dowsers115013533dows_ers
dusters84918363_dusters
easters75125683_easters
elaters74420193_elaters
enlisters937113enlisters
esters64627733__esters
falters103916473fal_ters
feasters11511563feasters
festers104121393_festers
fibsters13126413fibsters
filisters1237003filisters
filters103816553fil_ters
floaters112711513floaters
flossers11307863flossers
flouters11419273flouters
flusters113811503flusters
fluters103713683_fluters
folates103218453folate_s
folders113514393fol_ders
footers104618333fo_oters
foresters12312533foresters
foster94322223fo_ster_
gagsters10317083gagsters
gasters85624293_gasters
glisters93912603glisters
gloaters9288863gloaters
glossers9319053glossers
goiters84014443go_iters
golfers114410083gol_fers
gristers94013403gristers
gypsters1434023gypsters
hafters134614333h_afters
halers94926913hal__ers
halites103221193halite_s
halter94420883hal_ter_
haltere103614713hal_tere
halteres113414603hal_teres
halvers133311423hal_vers
hamster12810423hamster_
hastens106214813h_astens
hastes95727073h_aste_s
haters94930403h__aters
hatters104221523h_atters
haunters11329543haunters
hawsers13409483haws_ers
heaters104225223h_eaters
hefters134312003h_efters
heister103613623heister_
hellers103619833hel_lers
helpers123311853hel_pers
hillers103718733hil_lers
hinters103719583h_inters
hipster12288783hipster_
hissers104112313h_issers
hitters104717593h_itters
hoarders12307433hoarders
hoaxers17327133ho_axers
hobbers143512343ho_bbers
hobblers15308513hobblers
hockers163915913ho_ckers
hoers85724923ho___ers
hoggers124512483ho_ggers
hoises94823673hois_e_s
hoisted113411293hoiste_d
hoists95516023hoist__s
holder104619653hol_der_
holdovers1643763holdovers
holeless1189363holeless
holes84748653hol__e_s
holier94921623hol_ier_
holies94630033hol_ie_s
holiness112512503holiness
holists104413963holist__s
holler93520613hol_ler_
hollies103420813hollie_s
holloes103818193holloe_s
holstering1447083holstering
holts85627913hol_t__s
homagers1486823homagers
homers114821973ho__mers
honers94324973ho__ners
honester1139713honester_
honkers143315233ho_nkers
honorers1139263honorers
hoofers134513323ho_ofers
hookers144916513ho_okers
hoopers123616483ho_opers
hoopster1335543hoopster_
hooter94123933ho_oter_
hoovers134312703ho_overs
hopers114222973ho__pers
hoplites13310543hoplite_s
hoppers143115143ho_ppers
horses94729343hors_e_s
horsier103013243horsier_
horste94817413horste__
horsts95817513horst__s
hosels94218603ho_s_els
hoser811529763ho_s_er_
hoses85443173ho_s_e_s
hoseys124614003ho_s_eys
hosier94219613ho_sier_
hosiery13337183ho_siery
hostas94515823ho_st_as
hosted105020343ho_ste_d
hostel93914153ho_ste_l
hostelers1246643ho_stelers
hostelry1443913ho_stelry
hostler103411023ho_stler_
hosts85526703ho_st__s
hotels94515513ho__tels
hotspurs1342843hotspurs
hotter94720083ho_tter_
hounders123111713hounders
housels105312133hous_els
houser95322283hous_er_
houses96032273hous_e_s
hoverers14289023hoverers
hovers124320253ho__vers
howitzers2441853howitzers
howlers133312353ho_wlers
hucksters1843653hucksters
hullers103616263hul_lers
hunters103915733h_unters
hurters103413643h_urters
huskers143510043h_uskers
hustlers11349203h_ustlers
idolaters1045713idolaters
iolites73819483iolite_s
jesters144118193_jesters
jilters144211963jil_ters
jointers15289323jointers
jokesters2044443jokesters
jolliers15357433jolliers
jolter133513093jol_ter_
joshers174111593jo_shers
jostlers15357683jo_stlers
jotters143413803jo_tters
jouster143311043jouster_
justers143815733_justers
keesters12319593keesters
keisters123212043keisters
kelters113813753kel_ters
keysters15326333keysters
kiesters123310153kiesters
kilters113813603kil_ters
klisters123910483klisters
koshers144811803ko_shers
lamsters1099753lamsters
lasters75627693_lasters
leisters83312823leisters
listers74026533_listers
liters65429883__liters
lobster9288853lobster_
locaters102710073locaters
lofters103912903lo_fters
loiters74116613lo_iters
lollers72713793lol_lers
looters74419163lo_oters
losers65123583lo_s_ers
lotters73921063lo_tters
lusters73921443_lusters
maltsters1135193maltsters
masters94628923_masters
meisters103313843meisters
melters93918313mel_ters
milters93619093mil_ters
minsters103813923minsters
misters93927513_misters
mobster11299213mobster_
moistens10268773moistens
moister94015373moister_
molders103315553mol_ders
molester1099373molester_
molter84119423mol_ter_
momsers113810843moms_ers
monster93214603monster_
monstera10318883monstera
monsteras11318243monsteras
mooters93818623mo_oters
moshers124017843mo_shers
mossers94116193mo_ssers
moulters103510783moulters
mounters103712503mounters
mousers95216443mous_ers
munsters104010553munsters
musters94522513_musters
nesters74422793_nesters
noosers74913923noos_ers
noshers103614333no_shers
noters64021003no__ters
oaters65029793_o_aters
oldster896573_oldster_
oleasters936733_oleasters
oolites72817843oolite_s
osiers63412793_o_siers
ostlers72911203_o_stlers
otters64021513_o_tters
ouster64223733_ouster_
outers64230173_o_uters
oxters134813273_o_xters
oyster94111703_oyster_
palters94021683pal_ters
pasters94531733_pasters
pelters93720313pel_ters
pensters103012123pensters
pesters93827093_pesters
philters1398173phil_ters
piasters102912813piasters
pilasters1138223pilasters
pilsners1035533pilsners
plasters103518133plasters
platers93924093_platers
plotters104011553plotters
pointers103013723pointers
poisers94214433pois_ers
polders103617373pol_ders
polers84225643pol__ers
polestars1157283polestars
policers12259993policers
polishers1477603polishers
politer92417073politer_
pollers93420023pol_lers
pollster1037103pollster_
polluters1135033polluters
polyesters1545233polyesters
polymers1538333polymers
poofters1336923poofters
porters93722703po_rters
posers84223973po_s_ers
poster84129173po_ster_
postern93615613po_stern
posterns102713723po_sterns
potters94024343po_tters
poulters103911053poulters
pouters94221873po_uters
powters124015663po_wters
presters103419003presters
pulsers94213153puls_ers
punsters103310583punsters
questers17168763questers
rasters74629023_rasters
relaters83218153relaters
resters74130403_resters
roadsters1035103roadsters
roaster74116663roaster_
roister73516203roister_
rolfers104011813rol_fers
rollers73117473rol_lers
roosers74217873roos_ers
rooster74415173rooster_
rooters74522933ro_oters
roster64329083ro_ster_
rotters74421393ro_tters
rousers75220143rous_ers
rouster73517083rouster_
routers74822873ro_uters
royster103110533royster_
salters73622253sal_ters
saluters8319863saluters
shelters113412813shel_ters
shooters112811583sho_oters
shouters113510623sho_uters
shysters14106463shysters
sisters73721593_sisters
slaters73123733_slaters
slotters84012403slotters
solacers10268893solacers
solates73523853solate_s
solders83517773sol_ders
soldiers9277773soldiers
solutes73515263solute_s
solvers104414253sol_vers
songsters1046113songsters
sorters74221133so_rters
souters74422603so_uters
tapsters10318803tapsters
tasters74225643_tasters
testers74124543_testers
thirsters1235233thirsters
throwsters1642713throwsters
thrusters1245333thrusters
tilters73315953til_ters
tipsters10278513tipsters
toaster74414463toaster_
tollers73217463tol_lers
tooters73818773to_oters
tossers74713503to_ssers
toters65026363to__ters
totters74618733to_tters
touters74018353to_uters
trusters83112263trusters
trysters11298373trysters
twisters11268173twisters
ulster63712103_ulster_
upholster1442683upholster_
upholstery1851853upholstery
violaters1245963violaters
voltes94915583vol_te_s
volutes102710983volute_s
vomiters1337203vomiters
voters95017443vo__ters
waisters113811523waisters
wasters104026593_wasters
websters1335803websters
welshers14246813welshers
welters103516063wel_ters
westers105221963_westers
wolfers13409633wol_fers
wolvers13349313wol_vers
worsteds1234483worsteds
wowsers13488763wows_ers
wresters112711733wresters
xysters17307163_xysters
zesters163517293_zesters
zoolaters1844983zoolaters
zoster153715853zo_ster_

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 Limit1461624367.11020557.2
3Display Results4364360.1862344.1
 (SQL Overall)1786914367.70223200.6
 
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.