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

160 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
sclaffs154357(None) 
sclaff1438311sclaff_
blaffs14426622_blaffs
caffs135417372_c_affs
chaffs17459612_chaffs
cliffs14477592_cliffs
pilaffs15365152pilaffs
scarfs114714682sc_arfs
sclaffed17102672sclaffed
sclaffer16112652sclaffer
sclaffers17122522sclaffers
scoffs14347502sc_offs
scruffs1554172scruffs
scuffs14419052sc_uffs
sluffs12349582s_luffs
spliffs1533562spliffs
staffs12349752s_taffs
baffs134718053__baffs
blaff135216483_blaff_
bluffs14388373_bluffs
cafes106426923_c_afes
caff125631673_c_aff_
calfs104919383_c_alfs
califs114915893_califs
chafes145017913_chafes
chaff165016283_chaff_
chaffy20456473_chaffy
chuffs17427783_chuffs
clachs133511323_clachs
clacks144516343_clacks
clades94920463_clades
clads85722733_cla_ds
clags85621123_cla_gs
claims105211573_claims
clamps124515083_clamps
clams95127673_cla_ms
clangs95113613_clangs
clanks124615183_clanks
clans75031013_cla_ns
claps95626183_cla_ps
claros84015113_claros
clasps104512093_clasps
class75525483_cla_ss
clasts84817293_clasts
claves115020063_claves
clavus11347353_clavus
claws106020833_cla_ws
clays105521333_cla_ys
clefs106616243_cl_efs
clefts114610163_clefts
cliff135917133_cliff_
cliffy17435243_cliffy
clifts11519153_clifts
coffs134916303_c_offs
crafts115312743_crafts
cuffs135017493_c_uffs
daffs125116423__daffs
draffs13617903_draffs
eclairs935963eclairs
eclats8313033ecla_ts
fluffs11347783_fluffs
gaffs124914653__gaffs
gliffs13436323_gliffs
luffs114516283__luffs
naffs116213963__naffs
pilaff143910363pilaff_
pilafs113511023pila_fs
quaffs21125693_quaffs
raffs115017523__raffs
safes85226723s__afes
salaams997703salaams
salads75316963sala_ds
salals65120083sala_ls
salamis9313513salamis
scabs94818643sc_a_bs
scads85419963sc_a_ds
scags85520973sc_a_gs
scalades11258803scalades
scalados11276083scalados
scalages113010253scalages
scalares103210983scalares
scalars93711903scalars
scalds94813693sc_alds
scalers93817263scalers
scales84529313sc_ales
scalls84218203sc_alls
scalps104315233sc_alps
scamps125014173sc_amps
scams94423973sc_a_ms
scans74625103sc_a_ns
scants85219723sc_ants
scapes105122263sc_apes
scares85033003sc_ares
scarf105427143sc_arf_
scarps104718603sc_arps
scars75433533sc_a_rs
scarts85321493sc_arts
scats75930603sc_a_ts
scatts85914663sc_atts
scaups105411933sc_aups
scaurs85512053sc_aurs
schavs1436493scha_vs
sclaffing1843363sclaffing
scleras948223scleras
scoff134413343sc_off_
scrags95713803scra_gs
scrams105216623scra_ms
scrapes116217663scrapes
scraps106017243scra_ps
scrawls12177283scrawls
scruff1437963scruff_
scruffy1842643scruffy
scuff133914893sc_uff_
scurfs113210813sc_urfs
selahs9313213sela_hs
selfs85220243sel__fs
selloffs1443633selloffs
setoffs1334133setoffs
shafts125411443s_hafts
sheafs124912883shea_fs
shroffs1634363shroffs
silages82514443silages
silanes72517163silanes
skiffs16327013s_kiffs
slabs75322643s_la_bs
slacks124416533s_lacks
slags66525903s_la_gs
slakes104021883s_lakes
slams74927903s_la_ms
slangs75615343s_langs
slants64819083s_lants
slaps76025713s_la_ps
slates64934063s_lates
slats55436903s_la_ts
slaves95023023s_laves
slaws85222713s_la_ws
slays85723683s_la_ys
sluff114016813s_luff_
snafus936743s_nafus
snarfs95113423s_narfs
sniffs12378843s_niffs
snuffs12358533s_nuffs
solaces93116133solaces
solands84412343solands
solanos74412853solanos
solans64122493sola_ns
solates73523853solates
spiffs14328473s_piffs
splakes1349673splakes
splats84817303spla_ts
splays114910873spla_ys
spliff1438603spliff_
staff113817713s_taff_
stiffs12389963s_tiffs
strafes104516003strafes
stuffs123810223s_tuffs
sulfas9311563sul_fas
swarfs125612063s_warfs
waffs146315473__waffs
yaffs145311123__yaffs

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271605.86022871.5
3Display Results1601600.0463478.3
 (SQL Overall)1786911606.32928233.7
 
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.