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

285 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
howffs1853504(None) 
howff175110491howff_
howfs144814501how_fs
boffs134915502bo_ffs
coffs134916302co_ffs
doffs125614332do_ffs
hoofs115721042ho_ofs
howes114730262how_es
howf136127202how_f_
howks155016852how_ks
howls116219222how_ls
hows106345602how__s
huffs144514742h_uffs
offs107117012_o_ffs
pouffs14418122pouffs
showoffs2042452showoffs
toffs116016722to_ffs
baffs134718053_baffs
biffs134814413_biffs
blaffs14426623blaffs
blowoffs1942083blowoffs
bluffs14388373bluffs
boff124727333bo_ff_
boffo136010373bo_ffo
boffos14568193boffos
bouffe14438313bouffe
bouffes15388633bouffes
bowels114315593bowels
bowers115523703bowers
bowfin14338353bowfin
bowfins15267703bowfins
bowls106121433bow_ls
bows96242863bow__s
bowses115718863bowses
buffs135519513_buffs
caffs135417373_caffs
chaffs17459613chaffs
chows135618203chow__s
chowses155611283chowses
chuffs17427783chuffs
cliffs14477593cliffs
coff126930783co_ff_
coiffe1447043coiffe
coiffes1546803coiffes
coifs105718703co_ifs
coofs105924713co_ofs
cowers114625533cowers
cowfish1836433cowfish
cowls106922213cow_ls
cows97046643cow__s
cuffs135017493_cuffs
daffs125116423_daffs
dhows125911223dhow__s
diffs126315483_diffs
doff116225783do_ff_
doofus1036163doofus
dowels104813343dowels
dowers104523293dowers
downs94918573dow_ns
dows85941053dow__s
dowses105718303dowses
draffs13617903draffs
duffs125216623_duffs
effs105114033__effs
feoffs1163703feoffs
fluffs11347783fluffs
fowls115518893fow_ls
gaffs124914653_gaffs
gliffs13436323gliffs
golfs95616103go_lfs
gonefs10439873gonefs
goniffs14473903goniffs
gonifs104310133gonifs
gonofs10459863gonofs
goofs94821003go_ofs
gowans105512293gowans
gowds105814043gow_ds
gowks136011953gow_ks
gowns95115103gow_ns
griffs13398993griffs
gruffs13337453gruffs
guffs124414823_guffs
haafs115711163h_aafs
hafts116219463h_afts
hawks155415703haw_ks
haws106439443haw__s
hawses125113993hawses
hefts116218153h_efts
hewers123715273hewers
hews105631573hew__s
hoards104912623hoards
hoars85925553ho_ars
hoaxes163611693hoaxes
hoboes114717443hoboes
hobos106321353ho_bos
hobs97038983ho__bs
hocks144925493ho_cks
hocus104715203ho_cus
hodads1147963hodads
hods87239863ho__ds
hoers85724923ho_ers
hoes75755733ho__es
hogans105914313hogans
hogfish17257023hogfish
hoggs107212463ho_ggs
hogs87139663ho__gs
hoicks15378283hoicks
hoises94823673hoises
hoists95516023hoists
hokes126231643ho_kes
hokums1533923hokums
holds94623243ho_lds
holes84748653ho_les
holies94630033holies
holks124720563ho_lks
hollas94616903hollas
hollos95320633hollos
holms105117803ho_lms
hols76946293ho__ls
holts85627913ho_lts
homers114821973homers
homes106938813ho_mes
homeys145012873homeys
homies114524723homies
hommos13128503hommos
homos105921783ho_mos
honans94814503honans
hondas10313353hondas
honers94324973honers
hones88144493ho_nes
honeys124016083honeys
hongs95126203ho_ngs
honks125124523ho_nks
honors94816793honors
hons77350783ho__ns
hoods95124083ho_ods
hooeys125512313hooeys
hoof106036583ho_of_
hoofed134614893hoofed
hoofer124014953hoofer
hoofers134513323hoofers
hookas135312493hookas
hooks125027123ho_oks
hoops105621073ho_ops
hoots84830253ho_ots
hooves124815483hooves
hopers114222973hopers
hopes105835643ho_pes
hops97942633ho__ps
horahs126313873horahs
horas86333103ho_ras
hordes104921633hordes
horns86125333ho_rns
horses94729343horses
horsts95817513horsts
hos68364193ho___s
hosels94218603hosels
hosers95223963hosers
hoses85443173ho_ses
hoseys124614003hoseys
hostas94515823hostas
hosts85526703ho_sts
hotels94515513hotels
hots78349333ho__ts
hounds104413133hounds
houris94514583houris
hours85422393ho_urs
houses96032273houses
hovels125413333hovels
hovers124320253hovers
how97252433how___
howdah1634723howdah
howdahs1733613howdahs
howdie13349733howdie
howdies142911953howdies
howdy155711413how_dy
howe106734103how__e
howk145221963how__k
howked177312343howked
howl107625693how__l
howled134014973howled
howler123514313howler
howlers133312353howlers
howlet123518343howlet
howlets13329223howlets
hoyas115016163ho_yas
hoyles12315013hoyles
hoys107733933ho__ys
huff135623843h_uff_
huffy174810233h_uffy
jiffs185710313_jiffs
jowars16369653jowars
jowls156214523jow_ls
jows146632093jow__s
loafs85616993lo_afs
lofts85518363lo_fts
loofas9429833loofas
loofs85623783lo_ofs
lowers94624923lowers
lowes85732463low_es
lows75843013low__s
luffs114516283_luffs
miffs134512883_miffs
motifs1139673motifs
mowers113219403mowers
mows96340833mow__s
muffs134114213_muffs
naffs116213963_naffs
noways12127733noways
nows75738233now__s
nowts86915863now_ts
oafs76425263_o_afs
off96331633_o_ff_
owes75137103_ow_es
owls76022933_ow_ls
owns76819583_ow_ns
poofs105222793po_ofs
pouff135215423pouff_
pouffe14448263pouffe
pouffes15408123pouffes
pouffy17395883pouffy
poufs105616063po_ufs
powers113822323powers
pows95537663pow__s
puffs134114933_puffs
quaffs21125693quaffs
quiffs21135433quiffs
raffs115017523_raffs
riffs115114613_riffs
rolfs84817123ro_lfs
roofs85321153ro_ofs
rowans95715343rowans
rowels94515453rowels
rowens94515303rowens
rowers94924573rowers
rows75941753row__s
rowths12458173rowths
ruffs114516743_ruffs
scoffs14347503scoffs
scuffs14419053scuffs
showers134612683showers
showoff1943893showoff
shows115324583show__s
shroffs1634363shroffs
skiffs16327013skiffs
sluffs12349583sluffs
sniffs12378843sniffs
snuffs12358533snuffs
sofas85320713so_fas
softs85019233so_fts
sowans94215893sowans
sowars94318013sowars
sowens93613153sowens
sowers94923443sowers
sows75342493sow__s
spiffs14328473spiffs
staffs12349753staffs
stiffs12389963stiffs
stuffs123810223stuffs
teffs115111733_teffs
tiffs114414883_tiffs
toff105929903to_ff_
toffy145310283to_ffy
tofts84919243to_fts
tofus86415423to_fus
towels94314643towels
towers94423673towers
towies93521193towies
towns86018883tow_ns
tows78545553tow__s
tuffs115118263_tuffs
vowels124410483vowels
vowers124317183vowers
vows106626943vow__s
waffs146315473_waffs
whiffs1835083whiffs
whoofs15457243who_ofs
wolfs116214163wo_lfs
woofs114918003wo_ofs
wows104633493wow__s
yaffs145311123_yaffs
yowes114926373yow_es
yowies123913733yowies
yowls115715433yow_ls
yows106433123yow__s

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162855.23321539.5
3Display Results2852850.0763750.0
 (SQL Overall)1786912855.68531432.0
 
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.