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

223 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
sclaff143831(None) 
sclaffs1543571sclaffs
blaff135216482_blaff
caff125631672_c_aff
chaff165016282_chaff
cliff135917132_cliff
pilaff143910362pilaff
scarf105427142sc_arf
sclaffed17102672sclaffed
sclaffer16112652sclaffer
scoff134413342sc_off
scruff1437962scruff
scuff133914892sc_uff
sluff114016812s_luff
spliff1438602spliff
staff113817712s_taff
aff95537613___aff
baff124632273__baff
blaffs14426623_blaffs
bluff134413833_bluff
cafe95230323_c_afe
caffs135417373_c_affs
calf96339563_c_alf
calfs104919383_calfs
calif104929103_calif
chafe135117353_chafe
chaffs17459613_chaffs
chaffy20456473_chaffy
chuff164812493_chuff
clach124617823_clach
clack134720173_clack
clad76225823_cla_d
clade85821013_clade
clads85722733_clads
clag75924573_cla_g
clags85621123_clags
claim95616913_claim
clam86332293_cla_m
clamp115517653_clamp
clams95127673_clams
clan65633923_cla_n
clang86019313_clang
clank114719523_clank
clans75031013_clans
clap86429043_cla_p
claps95626183_claps
clapt98027173_clapt
claro75018693_claro
clary105719613_clary
clash106219033_clash
clasp95517193_clasp
class75525483_class
clast76030583_clast
clave105420153_clave
clavi104912923_clavi
claw95624343_cla_w
claws106020833_claws
clay95927413_cla_y
clays105521333_clays
clef97028183_cl_ef
clefs106616243_clefs
cleft106222853_cleft
cliffs14477593_cliffs
cliffy17435243_cliffy
clift106422193_clift
coff126930783_c_off
craft105327663_craft
cuff125327993_c_uff
daff115229683__daff
draff125615663_draff
eclair836813eclair
eclat7523603ecla_t
eclats8313033eclats
fluff103913613_fluff
gaff114828153__gaff
gliff124915663_gliff
luff104426703__luff
naff105128933__naff
pilaf103923483pila_f
pilaffs15365153pilaffs
pilafs113511023pilafs
quaff201311353_quaff
raff104933043__raff
safe75930953s__afe
salaam8711013salaam
salad65321833sala_d
salads75316963salads
salal55425703sala_l
salals65120083salals
salami8313103salami
salary9515213salary
salify12311373salify
scab85926713sc_a_b
scabs94818643sc_abs
scad75725773sc_a_d
scads85419963sc_ads
scag76626893sc_a_g
scags85520973sc_ags
scalade10359263scalade
scalado10276473scalado
scalage103110533scalage
scalar83612433scalar
scalare93311833scalare
scalars93711903scalars
scald84818123sc_ald
scalds94813693scalds
scale74629143sc_ale
scaled94822443scaled
scaler84321603scaler
scales84529313scales
scall74420373sc_all
scalls84218203scalls
scalp95217983sc_alp
scalps104315233scalps
scaly104718723sc_aly
scam85932353sc_a_m
scamp115717313sc_amp
scams94423973sc_ams
scan65530453sc_a_n
scans74625103sc_ans
scant79735073sc_ant
scape96921843sc_ape
scar66434203sc_a_r
scare75334463sc_are
scarfs114714683scarfs
scarp95724103sc_arp
scars75433533sc_ars
scart76139773sc_art
scary105222593sc_ary
scat65848373sc_a_t
scats75930603sc_ats
scatt76030093sc_att
scaup95515993sc_aup
scaur75814903sc_aur
schav1338313scha_v
schavs1436493schavs
sclaffers17122523sclaffers
sclaffing1843363sclaffing
sclera838893sclera
scoffs14347503scoffs
scrag85916173scra_g
scrags95713803scrags
scram910621623scra_m
scrams105216623scrams
scrap97120403scra_p
scrape105917573scrape
scraps106017243scraps
scrawl11208093scrawl
scruffs1554173scruffs
scruffy1842643scruffy
scuffs14419053scuffs
scurf104719323sc_urf
scurfs113210813scurfs
scurfy14338763scurfy
selah8319613sela_h
selahs9313213selahs
self75138293sel__f
selfs85220243sel_fs
selloff1345923selloff
setoff1238913setoff
shaft115725273s_haft
sheaf115424123shea_f
sheafs124912883sheafs
shroff1538503shroff
silage72715303silage
silane62718053silane
skiff153612803s_kiff
slab67133763s_la_b
slabs75322643s_labs
slack115021763s_lack
slag55934353s_la_g
slags66525903s_lags
slain54923573s_lain
slake93724053s_lake
slam67737973s_la_m
slams74927903s_lams
slang66324023s_lang
slank95822773s_lank
slant55238703s_lant
slap66434043s_la_p
slaps76025713s_laps
slash84719683s_lash
slat46959023s_la_t
slate55438283s_late
slats55436903s_lats
slaty86523153s_laty
slave84224033s_lave
slaw77930713s_la_w
slaws85222713s_laws
slay76436383s_la_y
slays85723683s_lays
sluffs12349583s_luffs
snafu8412143s_nafu
snarf86525423s_narf
sniff113915863s_niff
snuff113514043s_nuff
sola45541863sola__
solace83415823solace
solan55328153sola_n
soland75115043soland
solano65314183solano
solans64122493solans
solar55927343sola_r
solate64526073solate
spiff133616403s_piff
splake1259783splake
splash1168823splash
splat76129343spla_t
splats84817303splats
splay105816043spla_y
splays114910873splays
spliffs1533563spliffs
staffs12349753s_taffs
stiff114219243s_tiff
strafe95215983strafe
stuff113817053s_tuff
sulfa8313923sul_fa
sulfas9311563sulfas
sulfo8313363sul_fo
swarf115324653s_warf
waff134228043__waff
yaff135324263__yaff
yclad11246383ycla_d

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 Filter1786911127160.393454684.5
2DLD Change Limit1127162236.20318171.2
3Display Results2232230.1401592.9
 (SQL Overall)1786912236.73626527.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.