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

274 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
quaffs2112569(None) 
quaff201311351quaff_
quiffs21135431quiffs
baffs134718052_baffs
blaffs14426622blaffs
buffs135519512bu_ffs
caffs135417372_caffs
chaffs17459612chaffs
cuffs135017492cu_ffs
daffs125116422_daffs
draffs13617902draffs
duffs125216622du_ffs
gaffs124914652_gaffs
guffs124414822gu_ffs
huffs144514742hu_ffs
luffs114516282lu_ffs
muffs134114212mu_ffs
naffs116213962_naffs
puffs134114932pu_ffs
quacks214710102quacks
quads154515842qua_ds
quaffed2334252quaffed
quaffer2235132quaffer
quaffers2333962quaffers
quags154613252qua_gs
quails153412642quails
quais144618392qua_is
quakes194013342quakes
qualms17317242qualms
quants153614142quants
quarks193810912quarks
quarts154715932quarts
quass144413762qua_ss
quays174612042qua_ys
quiff201111562quiff_
raffs115017522_raffs
ruffs114516742ru_ffs
staffs12349752staffs
tuffs115118262tu_ffs
waffs146315472_waffs
yaffs145311122_yaffs
aff95537613__aff_
aquas142412613aqua__s
arfs76029963__arfs
baff124632273_baff_
baffy165511923_baffy
barfs104826003_barfs
biffs134814413_biffs
blaff135216483blaff_
bluffs14388373bluffs
boffs134915503_boffs
buff125229863bu_ff_
buffi136112203bu_ffi
buffo135112183bu_ffo
buffos14447853buffos
buffy165013373bu_ffy
bumfs125414053bu_mfs
buyoffs1842433buyoffs
cafes106426923_cafes
caff125631673_caff_
calfs104919383_calfs
chafes145017913chafes
chaff165016283chaff_
chaffy20456473chaffy
chuffs17427783chuffs
cliffs14477593cliffs
coffs134916303_coffs
crafts115312743crafts
cuff125327993cu_ff_
cuifs104814693cu_ifs
curfs105122143cu_rfs
cutoffs1533603cutoffs
daff115229683_daff_
daffy155510283_daffy
diffs126315483_diffs
doffs125614333_doffs
draff125615663draff_
draffy16486633draffy
drafts105012533drafts
duads76515343dua_ds
duals65620083dua_ls
duff114326643du_ff_
dufus94010813du_fus
dwarfs13436273dwarfs
effs105114033__effs
equals1538693equa_ls
equates162012323equates
feoffs1163703feoffs
fluffs11347783fluffs
gaff114828153_gaff_
gaffe124111653_gaffe
gaffes134811103_gaffes
gliffs13436323gliffs
grafts105013253grafts
griffs13398993griffs
gruffs13337453gruffs
guacos94410313guacos
guanos73811993guanos
guans64419443gua_ns
guards84611573guards
guars65021053gua_rs
guavas1037163guavas
guff114624933gu_ff_
gulfs94915303gu_lfs
haafs115711163_haafs
hafts116219463_hafts
howffs18535043howffs
huff135623843hu_ff_
huffy174810233hu_ffy
jiffs185710313_jiffs
kafs116423743_ka_fs
kaifs125715643_kaifs
khafs15648843kha_fs
krafts13438853krafts
kufis1249253ku_fis
leafs85721183lea_fs
loafs85616993loa_fs
luaus54514903lua_us
luff104426703lu_ff_
luffa11409023lu_ffa
luffas12337483luffas
miffs134512883_miffs
muff124723863mu_ff_
naff105128933_naff_
naifs87617423_naifs
oafs76425263_oa_fs
offs107117013__offs
piaffe1494913piaffe
piaffes15115053piaffes
pilaffs15365153pilaffs
pouffs14418123pouffs
puff125525433pu_ff_
puffy164410753pu_ffy
putoffs1543333putoffs
qadis155917853q_adis
qaids156116313q_aids
qats135331343q_a_ts
qua124821973qua___
quack203812503qua_ck
quacky24376963quacky
quad144618703qua__d
quaere154110673quaere
quaeres163310843quaeres
quaffing2434353quaffing
quag144815943qua__g
quagga1754143quagga
quaggas1893703quaggas
quaggy2084683quaggy
quahog1944103quahog
quahogs2043163quahogs
quai134420393qua__i
quaich2047693quaich
quaichs2144633quaichs
quaigh1935463quaigh
quaighs2043493quaighs
quail144314363qua_il
quaint15415173quaint
quake184114643qua_ke
quaked203910033quaked
quaker193811623quaker
quakers20309693quakers
quaky214310743qua_ky
quale143617853qua_le
qualia1559563qualia
qualify2235473qualify
qualm163511183qua_lm
qualmy20285803qualmy
quamash2144293quamash
quango1636493quango
quangos1734653quangos
quant143624813qua_nt
quanta153911333quanta
quare143920543qua_re
quark184614123qua_rk
quarry1837473quarry
quart144027853qua_rt
quarte154115323quarte
quartes163314933quartes
quarto153511123quarto
quartos16328733quartos
quartz244212103quartz
quasar1536833quasar
quasars1646903quasars
quash174512163qua_sh
quashes192110973quashes
quasi144015023qua_si
quasses16209503quasses
quate144521413qua_te
quatre153512353quatre
quatres163411933quatres
quaver18309313quaver
quavers19309013quavers
quay164618353qua__y
qubits173710353qubits
queans153110753queans
queens15338873queens
queers153510773queers
quells15359703quells
querns15307943querns
quests153310353quests
queues153510193queues
queys17398363qu_eys
quicks21389303quicks
quids154917463qu_ids
quiets154014373quiets
quills153811853quills
quilts154112543quilts
quins144819853qu_ins
quints154316563quints
quips164713373qu_ips
quipus17458003quipus
quires154015743quires
quirks19419113quirks
quirts154213553quirts
quits144122353qu_its
quods154610223qu_ods
quoins154110583quoins
quoits15379683quoits
quolls15327303quolls
quotas15339433quotas
quotes153312463quotes
raff104933043_raff_
rafts87820633_rafts
riffs115114613_riffs
ruanas6311263ruanas
ruboffs1543123ruboffs
ruff105127653ru_ff_
ruffe114713813ru_ffe
ruffes124112423ruffes
runoffs1343013runoffs
safes85226723_safes
scarfs114714683scarfs
sclaffs1543573sclaffs
scoffs14347503scoffs
scuffs14419053scuffs
shafts125411443shafts
skiffs16327013skiffs
sluffs12349583sluffs
snafus936743snafus
snarfs95113423snarfs
sniffs12378843sniffs
snuffs12358533snuffs
spiffs14328473spiffs
squabs17429323squa_bs
squads164410293squa_ds
squalls1647313squalls
squares163714463squares
squarks20417183squarks
squats153712963squa_ts
squawks23294883squawks
squaws18438783squa_ws
squiffy2542573squiffy
staff113817713staff_
stiffs12389963stiffs
stuffs123810223stuffs
sulfas9311563sulfas
surfs85022543su_rfs
swarfs125612063swarfs
taffy145110823_taffy
teffs115111733_teffs
tiffs114414883_tiffs
toffs116016723_toffs
tufas85314383tu_fas
tuff104528523tu_ff_
tufts85713273tu_fts
turfs84620443tu_rfs
waff134228043_waff_
wafts116920553_wafts
waifs115719873_waifs
wharfs1546373wharfs
whiffs1835083whiffs
yaff135324263_yaff_
yuans84613323yua_ns
zarfs174713623_zarfs

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.390458182.1
2DLD Change Limit1127162744.71623900.8
3Display Results2742740.0803425.0
 (SQL Overall)1786912745.18634456.4
 
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.