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

521 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
hostess10321023(None) 
hostels103712311hostels
cohostess1443432cohostess
costers94128302costers
costless10310002costless
fosters104220092fosters
hastens106214812hastens
hastes95727072haste_s
hoisters113513472hoisters
holsters113211932holsters
hooters104520462hooters
horstes104516112horste_s
hosels94218602hos_els
hosers95223952hos_ers
hoses85443172hos_e_s
hoseys124614002hos_eys
hosiers104212632hosiers
hostas94515822host_as
hosted105020342hoste_d
hostel93914152hoste_l
hostessed1344352hostessed
hostesses1247172hostesses
hostlers113310482hostlers
hosts85526702host__s
hotels94515502ho_tels
hotness1038602hotness
hottest10411382hottest
lostness837682lostness
mostest9314792mostest
mostests1036832mostests
poetess938932poetess
possess9419112possess
posters93927992posters
rosters73727532rosters
zosters163015402zosters
abscess1133903abscess
assess65710463_assess
asters65631603_asters
basters94930303basters
bastes85330383baste_s
bisters93922603bisters
boasters103915653boasters
boatels93510233boatels
boaters93419233boaters
boites84322703boite_s
bolsters103712443bolsters
bolters94017803bolters
boltless10338283boltless
boosters104013433boosters
bootees94114473bootees
bootless103410983bootless
boshes114721883boshe_s
boskets13409473boskets
bosses85925403bosse_s
bostons9312893bostons
botels84815803bo_tels
bowless123310313bowless
busters94724123busters
casters94729893casters
castes85631863caste_s
chastens13429183chastens
chastest1349703chastest
chortens13308793chortens
choses115825123chos_e_s
coasters104317303coasters
coatees93816533coatees
coaters93525773coaters
coatless1039693coatless
colters93522433colters
comtes106222813comte_s
confess12399903confess
contes84432913conte_s
contessa1044583contessa
contest93523233contest
contests103413383contests
cooters94525713cooters
copters113621273copters
cosecs105015213cos_ecs
coses76949493cos_e_s
cosets85824403cos_ets
coseys115215813cos_eys
coshers123618173coshers
coshes115022783coshe_s
cosies84932153cosie_s
cosiest93819853cosiest
cosiness103214283cosiness
cossets95014283cossets
costars94217993costars
costed95623113coste_d
coster84331293coste_r
costrels1038933costrels
costs77231143cost__s
cotes76347843co_te_s
cotters94323433cotters
countess103710043countess
couters93827283couters
coxless1637743coxless
coyness1277323coyness
distress9311703distress
dosers75723633dos_ers
doses65938503dos_e_s
dossels85511603dossels
dossers84516233dossers
dosses76126273dosse_s
doters74423913do_ters
dotes65836693do_te_s
dottels8327783dottels
dotters83715973dotters
dusters84918353dusters
dustless9328343dustless
easters75125683easters
esters64627733_esters
fastens105511753fastens
fastest102413723fastest
fastness11238763fastness
festers104121393festers
fogless1138193fogless
footers104618333footers
footless113710803footless
fortes95327183forte_s
fortress1136753fortress
fosses96022083fosse_s
foster94322223foste_r
frosteds12305653frosteds
frostless1235743frostless
gasless8319013gasless
gasters85624283gasters
gastness9278473gastness
gestes75721393geste_s
ghosted1236273ghoste_d
ghostiest1336543ghostiest
ghosts10489273ghost__s
goatees82710433goatees
goddess1035263goddess
godless938403godless
goiters84014433goiters
gospels1035593gospels
gustless9287683gustless
hafters134614333hafters
halters104619803halters
haltless11308443haltless
hamsters13710423hamsters
hapless123311333hapless
haptens124511343haptens
harness102413933harness
hashes125024803hashe_s
haslets102510863haslets
hassels104311013hassels
haste85927863haste__
hasted105125283haste_d
hasten95718563haste_n
hastiest112916493hastiest
hastiness122410883hastiness
haters94930393h_aters
hates86742573h_ate_s
hatless103813443hatless
hatters104221523hatters
heaters104225213heaters
heatless113011463heatless
hefters134312003hefters
heiress1036813heiress
heisters113413133heisters
hests85829933hest__s
hiltless11297123hiltless
hinters103719573hinters
hipless12399923hipless
hipness12277383hipness
hipsters13268783hipsters
hissers104112313hissers
hisses94719353hisse_s
histed104420243histe_d
hists86328373hist__s
hitless103211193hitless
hitters104717583hitters
hoaxers17327133hoaxers
hoaxes163611693hoaxe_s
hobbers143512343hobbers
hoboes114717443hoboe_s
hockers163915913hockers
hockeys19509273hockeys
hocuses121710423hocuses
hoddens12378803hoddens
hoers85724923ho__ers
hoes75755733ho__e_s
hoggers124512483hoggers
hoggets12498323hoggets
hogties112813993hogties
hoidens11329083hoidens
hoises94823673hoise_s
hoisted113411293hoiste_d
hoister103714203hoiste_r
hoists95516023hoist__s
hokes126231643ho_ke_s
hokiest144114243hokiest
hokiness152510183hokiness
holders113715903holders
holeless1189363holeless
holes84748653ho_le_s
holies94630033holie_s
holiest104319623holiest
holiness112512503holiness
hollers103818233hollers
holstein1145003holstein
holsteins1245253holsteins
holster103512213holste_r
holts85627913holt__s
homeless131110133homeless
homers114821973ho_mers
homes106938813ho_me_s
homeys145012873ho_meys
homies114524723homie_s
homiest124116633homiest
hominess132712453hominess
honers94324973ho_ners
hones88144493ho_ne_s
honest94822423ho_nest
honestest1247303honestest
honeys124016083ho_neys
honkers143315233honkers
honkeys17439513honkeys
hoodless12289733hoodless
hooeys125512313ho_oeys
hoofers134513323hoofers
hoofless14258013hoofless
hookers144916513hookers
hookeys17448953hookeys
hookless151238363hookless
hoopers123616483hoopers
hoopless13279253hoopless
hoopsters1445673hoopsters
hooted104422653hoote_d
hooter94123923hoote_r
hootiest113115643hootiest
hoots84830243hoot__s
hoovers134312703hoovers
hooves124815483hoove_s
hopeless13118303hopeless
hopers114222973ho_pers
hopes105835643ho_pe_s
hoppers143115143hoppers
hordes104921633horde_s
hornets104113553hornets
hornless1137363hornless
horseless1237213horseless
horses94729343horse_s
horsiest112513263horsiest
horsiness12259463horsiness
horste94817413horste__
horsts95817513horst__s
hose76547243hos_e__
hosed95830983hos_e_d
hosel86024813hos_e_l
hosen85623883hos_e_n
hoser811529763hos_e_r
hosey116127023hos_e_y
hosier94219613hosie_r
hosiery13337183hosiery
host77852833host___
hosta85917833host__a
hostage113111233hostage
hostages122311693hostages
hosteled1237283hosteled
hosteler1137273hosteler
hostelers1246633hostelers
hostelry1443913hostelry
hostessing1444563hostessing
hostile10312553hostile
hostiles11312213hostiles
hosting114318383hosting
hostler103411023hostler
hostly124210863host_ly
hotbeds13315003hotbeds
hotel85520743ho_te_l
hotpress1344293hotpress
hots78349323ho_t__s
hotted104319933hotte_d
hotter94720073hotte_r
hotties103016953hotties
hottish13117893hottish
houseless1237463houseless
housels105312133housels
housers104717813housers
houses96032273house_s
hovels125413333ho_vels
hovers124320253ho_vers
howes114730263ho_we_s
howlers133312353howlers
howlets13329223howlets
hoydens14347403hoydens
hoyles12315013hoyle_s
hueless1058823hueless
hunters103915723hunters
huntress1144833huntress
hurters103413633hurters
hurtless11307783hurtless
hushes124718593hushe_s
huskers143510033huskers
hustlers11349203hustlers
hustles103414173hustles
insteps936573insteps
jesters144118193jesters
jobless16237563jobless
jolters143711993jolters
joshers174111593joshers
joshes165114853joshe_s
josses135117683josse_s
jostlers15357683jostlers
jostles143411143jostles
jotters143413803jotters
jousters153210403jousters
joyless17226513joyless
justers143815723justers
justest1449893justest
justness1535323justness
koshers144811803koshers
lasters75627693lasters
listees73416673listees
listels74212433listels
listens74014133listens
listers74026523listers
listless8269263listless
lobsters10268733lobsters
loess55714703lo__ess
lofters103912903lofters
loftless1135903loftless
loiters74116613loiters
looters74419163looters
losels64714583los_els
losers65123583los_ers
loses56742013los_e_s
losses65925233losse_s
lossless835473lossless
lotters73921063lotters
lottes65322753lotte_s
lowness1037813lowness
lusters73921433lusters
masters94628923masters
mastless102610023mastless
mestees94617753mestees
mesteso937133mesteso
mestesos1045223mestesos
misters93927503misters
mistress10310703mistress
mobsters12359053mobsters
moistens10268773moistens
moistest1038763moistest
moistness1146343moistness
molters93816973molters
monsters103314533monsters
montes84226933monte_s
mooters93818623mooters
mootness1036753mootness
moseys114711703mos_eys
moshers124017843moshers
moshes115222873moshe_s
mossers94116193mossers
mosses85527683mosse_s
moste75925083moste__
mosts76028543most__s
motels83616893mo_tels
motes75944003mo_te_s
motets84216193mo_tets
mottes85523693motte_s
mustees94614923mustees
musters94522493musters
nesters74422783nesters
noseless839513noseless
noses55435643nos_e_s
noshers103614323noshers
noshes96618233noshe_s
nosiest73415673nosiest
nosiness83211393nosiness
nostocs947533nostocs
noters64020993no_ters
notes55034583no_te_s
nowness1037033nowness
oaters65029783_oaters
obsess845943_obsess
obtest81213013_obtest
obtests9136233_obtests
octets839403_octets
oftest91212003_oftest
ogress7529503_ogress
oses46641513_os_e_s
osiers63412793_osiers
osteal6312953_osteal
osteoses839033_osteoses
osteosis846743_osteosis
ostlers72911203_ostlers
ostoses71213543_ostoses
ostosis71310113_ostosis
otters64021513_otters
ousters74122773ousters
outers64230163_outers
oxters134813273_oxters
oysters103411683oysters
pastels95215183pastels
pasters94531733pasters
pastes85233913paste_s
pastless102411203pastless
pastness102510503pastness
pesters93827093pesters
pistes85325633piste_s
poetless1038723poetless
pontes83627853ponte_s
porters93722703porters
portless10310643portless
portress1038313portress
posers84223973pos_ers
poses74642763pos_e_s
poshest12312423poshest
poshness1356643poshness
posies84431433posie_s
posses85128803posse_s
possets94212773possets
postals93716373postals
posted93722493poste_d
posteen93512613posteen
posteens10309723posteens
poster84129173poste_r
postern93615603postern
posterns102713703posterns
posties93128813posties
postins93721203postins
postops11311703postops
posts75228783post__s
posttest10410233posttest
posttests1144963posttests
potters94024343potters
pouters94221863pouters
powters124015653powters
rasters74629023rasters
resters74130403resters
restless82713163restless
restress82511773restress
roasters83615913roasters
rodless8310073rodless
roisters83615543roisters
roosters83514653roosters
rooters74522933rooters
rootless83910443rootless
roses56445773ros_e_s
rosets65819953ros_ets
rosiest73919213rosiest
rosiness82613173rosiness
roster64329083roste_r
rotes56143903ro_te_s
rotters74421393rotters
rottes64524833rotte_s
rousters84315653rousters
routers74822853routers
routes66129313route_s
roysters113610523roysters
rustless83510233rustless
sestets7911473sestets
shoeless1137803shoeless
shooters112811553shooters
shortens11288983shortens
shortest11310773shortest
shortness1236733shortness
shotes95321893sho_te_s
shouters113510593shouters
shysters14106433shysters
sisters73721573sisters
softens10347623softens
softest10310603softest
softness1136433softness
sonless72612613sonless
sorters74221113sorters
souters74422583souters
stems75219953__stems
steps76619883__steps
stets55423913__stets
stews85519143__stews
stoss54316343__stoss
stress66616673__stress
systems1234673systems
tasters74225643tasters
tastes64126423taste_s
testees74215913testees
testers74124543testers
testes65125823teste_s
thowless1434613thowless
toasters83912703toasters
toeless72612393toeless
tooters73818773tooters
tootses72910773tootses
topless92511123topless
tortes64826053torte_s
toshes94520103toshe_s
tossers74713493tossers
tosses65225393tosse_s
totems86810763to_tems
toters65026363to_ters
totes55139683to_te_s
totters74618733totters
touters74018333touters
toyless10268713toyless
ulsters72711983ulsters
unsteps936213unsteps
unstress837373unstress
upsteps1133743upsteps
vastest102911513vastest
vastness11257293vastness
vestees103513163vestees
vestless11258843vestless
voltes94915583volte_s
voters95017443vo_ters
votes84627083vo_te_s
votress1035483votress
vowless13246603vowless
wasters104026593wasters
wastes96224883waste_s
westers105221963westers
whosises1435333whosises
woeness1020211543woeness
worsteds1234483worsteds
xysters17307163xysters
zesters163517293zesters
zestless17247433zestless
zoster153715853zoste_r

Search took 9 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.1561145455.1
2DLD Change Limit1340275218.23316279.2
3Display Results5215210.2032566.5
 (SQL Overall)1786915218.59220797.4
 
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.