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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 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
daffs12511642(None) 
baffs134718051baffs
caffs135417371caffs
daff115229681daff_
daffy155510281daffy
diffs126315481diffs
doffs125614331doffs
draffs13617901draffs
duffs125216621duffs
gaffs124914651gaffs
naffs116213961naffs
raffs115017521raffs
waffs146315471waffs
yaffs145311121yaffs
aff95537612_aff_
arfs76029962_arfs
baff124632272baff_
baffy165511922baffy
barfs104826002barfs
biffs134814412biffs
blaffs14426622blaffs
boffs134915502boffs
buffs135519512buffs
cafes106426922cafes
caff125631672caff_
calfs104919382calfs
chaffs17459612chaffs
coffs134916302coffs
cuffs135017492cuffs
dabs77139402da_bs
daces85030682daces
dadas75819862dadas
dados75522432dados
dads67442772da_ds
daffed14429492daffed
daft85537252da_ft
dagos76419442dagos
dags66642602da_gs
dahls95012282dahls
dahs88231812da_hs
dais57040702da_is
daks97130602da_ks
dales66439742dales
dals57145122da_ls
dames85435852dames
damns84916922damns
damps105220412damps
dams77444372da_ms
dangs75623202dangs
dans56748152da_ns
daps77239162da_ps
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
dates65639152dates
datos65222782datos
daubs85014562daubs
dauts67822242dauts
dawks135213492dawks
dawns95916592dawns
daws86638242da_ws
dawts97216122dawts
days87637132da_ys
dazes155024142dazes
defis96717502defis
delfs94918672delfs
diff116228842diff_
difs86027322d_ifs
doff116225782doff_
draff125615662draff_
draffy16486632draffy
drafts105012532drafts
duff114326642duff_
dufus94010812dufus
dwarfs13436272dwarfs
effs105114032_effs
gaff114828152gaff_
gaffe124111652gaffe
gaffes134811102gaffes
guffs124414822guffs
haafs115711162haafs
hafts116219462hafts
huffs144514742huffs
jiffs185710312jiffs
kafs116423742ka_fs
kaifs125715642kaifs
luffs114516282luffs
miffs134512882miffs
muffs134114212muffs
naff105128932naff_
naifs87617422naifs
oafs76425262oa_fs
offs107117012_offs
puffs134114932puffs
quaffs21125692quaffs
raff104933042raff_
rafts87820632rafts
riffs115114612riffs
ruffs114516742ruffs
safes85226722safes
staffs12349752staffs
taffy145110822taffy
teffs115111732teffs
tiffs114414882tiffs
toffs116016722toffs
tuffs115118262tuffs
waff134228042waff_
wafts116920552wafts
waifs115719872waifs
yaff135324262yaff_
zarfs174713622zarfs

Search took 3 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.313570897.8
2DLD Change Limit538001131.70331591.3
3Display Results1131130.0303766.7
 (SQL Overall)1786911132.04687336.8
 
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.