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 “naffs” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
naffs11621396(None) 
baffs134718051baffs
caffs135417371caffs
daffs125116421daffs
gaffs124914651gaffs
naff105128931naff_
naifs87617421naifs
raffs115017521raffs
waffs146315471waffs
yaffs145311121yaffs
aff95537612_aff_
arfs76029962_arfs
baff124632272baff_
baffy165511922baffy
barfs104826002barfs
biffs134814412biffs
blaffs14426622blaffs
boffs134915502boffs
buffs135519512buffs
cafes106426922cafes
caff125631672caff_
calfs104919382calfs
chaffs17459612chaffs
coffs134916302coffs
cuffs135017492cuffs
daff115229682daff_
daffy155510282daffy
diffs126315482diffs
doffs125614332doffs
draffs13617902draffs
duffs125216622duffs
effs105114032_effs
gaff114828152gaff_
gaffe124111652gaffe
gaffes134811102gaffes
guffs124414822guffs
haafs115711162haafs
hafts116219462hafts
huffs144514742huffs
jiffs185710312jiffs
kafs116423742ka_fs
kaifs125715642kaifs
luffs114516282luffs
miffs134512882miffs
muffs134114212muffs
naans55815252naans
nabes75427092nabes
nabis76020582nabis
nabs66236192na_bs
nadas66320812nadas
naffed13408332naffed
nags55436022na_gs
naif76839022naif_
nails55730402nails
nakfa1236092nakfa
nakfas1334682nakfas
nalas55528362nalas
names74833362names
nanas55928632nanas
nans46139402na_ns
naos47429732na_os
napas75924352napas
napes74828462napes
naps66238582na_ps
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
nates55238332nates
naves87030382naves
nays75931592na_ys
nazis145216082nazis
neifs85613042neifs
oafs76425262oa_fs
offs107117012_offs
puffs134114932puffs
quaffs21125692quaffs
raff104933042raff_
rafts87820632rafts
riffs115114612riffs
ruffs114516742ruffs
safes85226722safes
snafus936742snafus
snarfs95113422snarfs
sniffs12378842sniffs
snuffs12358532snuffs
staffs12349752staffs
taffy145110822taffy
teffs115111732teffs
tiffs114414882tiffs
toffs116016722toffs
tuffs115118262tuffs
waff134228042waff_
wafts116920552wafts
waifs115719872waifs
yaff135324262yaff_
zarfs174713622zarfs

Search took 5 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 Filter178691538000.736242786.7
2DLD Change Limit53800983.57615044.7
3Display Results98980.0303266.7
 (SQL Overall)178691984.34241154.1
 
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.