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

128 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
quaffers233396(None) 
quaffer2235131quaffer_
buffers153310792bu_ffers
chaffers19378002chaffers
duffers143410092du_ffers
gaffers14428712_gaffers
gauffers1563832gauffers
piaffers16114202piaffers
puffers15349202pu_ffers
quaffed2334252quaffe_d
quaffs21125692quaff__s
quakers20309692qua_kers
quarters173110452quarters
quashers20186802quashers
quavers19309012qua_vers
staffers14247082staffers
suffers133113542su_ffers
zaffers22386772_zaffers
afters94717073__afters
aquifers2044393aqu_ifers
bafflers16356593_bafflers
bluffers16405703bluffers
buffer144512683bu_ffer_
buffets15317593bu_ffets
chafers154512743cha_fers
chaffer18389473chaffer_
chamfers18409223chamfers
chaufers16347303chaufers
chauffers20253443chauffers
coffers154112693_coffers
crafters13419953crafters
differs14339973_differs
doffers14359853_doffers
drafters12338523drafters
duffels14296453du_ffels
duffer134711663du_ffer_
feoffers1333133feoffers
fluffers13335293fluffers
gaffer134310133_gaffer_
gaffes134811103_gaffe_s
gauffer1474423gauffer_
goffers14409213_goffers
grafters12409193grafters
guarders1035883guarders
haffets1636053_haffets
hafters134614333_hafters
kaffirs17325553_kaffirs
loafers10349463loa_fers
lucifers1334163lucifers
mufflers16316003mufflers
niffers13287363_niffers
offers12349963__offers
piaffer15104443piaffer_
piaffes15115053piaffe_s
proffers16126593proffers
puffer144610733pu_ffer_
puffery18235113pu_ffery
purflers13216963purflers
quackery2633113quackery
quaere154110673qua__ere
quaeres163310843qua__eres
quaff201311353quaff___
quaffing2434353quaffing
quaker193811623qua_ker_
quakes194013343qua_ke_s
quakier20239203quakier_
qualifiers2243333qualifiers
quarrels1735083quarrels
quarriers1845183quarriers
quarter163211853quarter_
quartern17286473quartern
quarterns18285153quarterns
quartes163314933quarte_s
quartets17277573quartets
quartiers1845183quartiers
quasars1646903qua_sars
quasher19198623quasher_
quashes192110973quashe_s
quasses16209503quasse_s
quatres163411933quatre_s
quaver18309313qua_ver_
quaverers2143853quaverers
quavery22225483qua_very
queers153510773qu__eers
quellers17237533quellers
queriers1736963queriers
questers17168763questers
queuers16366393qu_euers
quieters17248733quieters
quiffs21135433quiff__s
quilters17228433quilters
quippers2184813quippers
quitters17238523quitters
quivers19298753qu_ivers
quizzers2542943quizzers
quoters16369263qu_oters
rafflers14317363_rafflers
rafters103715633_rafters
reoffers1434693reoffers
ruffes124112423ru_ffe_s
rufflers14347193rufflers
scarfers13408463scarfers
sclaffers17122523sclaffers
scoffers16286133scoffers
scuffers16307493scuffers
sniffers14257123sniffers
snuffers14326923snuffers
squallers1834683squallers
squanders1934443squanders
squarers17338023squa_rers
squashers21184983squashers
squatters1834943squatters
squawkers2542483squawkers
staffer13299093staffer_
stuffers14277383stuffers
suffer124314513su_ffer_
surfers103614133su_rfers
troffers14125433troffers
tuffets13266523tu_ffets
tufters10298353tu_fters
wafers124316143_wa_fers
wafflers17306323_wafflers
wafters134112813_wafters
whiffers2064493whiffers
zaffars22325233_zaffars
zaffer21397153_zaffer_
zaffirs22375663_zaffirs
zaffres22324993_zaffres

Search took 7 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.420425454.8
2DLD Change Limit1461621286.15623743.0
3Display Results1281280.0502560.0
 (SQL Overall)1786911286.62626968.2
 
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.