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

217 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
spliff143860(None) 
spiff133616401sp_iff
spliffs1533561spliffs
cliff135917132_cliff
gliff124915662_gliff
salify12311372salify
sclaff1438312sclaff
skiff153612802s_kiff
sluff114016812s_luff
sniff113915862s_niff
spiffs14328472sp_iffs
spiffy17326222sp_iffy
splice104915102splice
spline86020532spline
splint85223282splint
split75729012spli_t
splits85416412splits
stiff114219242s_tiff
uplift114610652uplift
alif76242143_ali_f
alifs86121263_alifs
amplify1744083amplify
aplite8316393aplite
bailiff1546073bailiff
belief115018603belief
biff125026893__biff
blaff135216483_blaff
bluff134413833_bluff
calif104929103cali_f
califs114915893califs
cliffs14477593_cliffs
cliffy17435243_cliffy
clift106422193_clift
diff116228843__diff
fluff103913613_fluff
gliffs13436323_gliffs
goniff13408893goniff
griff124416463_griff
iff96730393___iff
jiff175321413__jiff
kalif125021363kali_f
kalifs134410983kalifs
lief76036993__lief
life75433733__life
lift76942723__lift
luff104426703__luff
miff125625063__miff
pilaf103923483_pilaf
pilaff143910363pilaff
plica9613373_plica
plie65127393_pli_e
plied85118593_plied
plier75221283_plier
plies74526513_plies
plink115219123_plink
pouff135215423_pouff
puff125525433_p_uff
quiff201111563_quiff
relief94419683relief
riff104430103__riff
salic73424713sali_c
salina64221123salina
saline65132703saline
saliva93110743saliva
salsify1334703salsify
sapling103217863sapling
sclaffs1543573sclaffs
scoff134413343s_coff
scruff1437963scruff
scuff133914893s_cuff
sealift10312793sealift
seif75638733s_ei_f
seifs85019333s_eifs
self75138293sel__f
selfs85220243sel_fs
selloff1345923selloff
serif84132133seri_f
serifs94017053serifs
setoff1238913setoff
sheriff16287693sheriff
shift114225143s_hift
shoplift1645193shoplift
shrift12413543shrift
shroff1538503shroff
sift710740663s__ift
silica8311243silica
simplify1843553simplify
skiffs16327013s_kiffs
slice74925823s_lice
slick115520523s_lick
slid55828983s_li_d
slide64725413s_lide
slier54827243s_lier
slily85820033s_lily
slim66631963s_li_m
slime74925753s_lime
slims75423653s_lims
slimy105417423s_limy
sling66028803s_ling
slink95422913s_link
slip67031733s_li_p
slipe75626133s_lipe
slips76023723s_lips
slipt76627483s_lipt
slit46250103s_li_t
slits56128853s_lits
sluffs12349583s_luffs
sniffs12378843s_niffs
sniffy15337193s_niffy
snuff113514043s_nuff
soli46637013soli__
solid65025083soli_d
solidi73813153solidi
solids74116403solids
soling74226823soling
solion6616383solion
spail74921553spai_l
spails84817823spails
spait75631603spai_t
spaits85017473spaits
specify1764993specify
speil75618643spei_l
speils84116223speils
speir75315363spei_r
speirs85013233speirs
speise84614253speise
speiss84311643speiss
sphinx1866203sphinx
spic85227433sp_i_c
spica94717943sp_ica
spice95528813sp_ice
spick134519073sp_ick
spics94123243sp_ics
spicy125417713sp_icy
spied85427713sp_ied
spiel74623913sp_iel
spier75728033sp_ier
spies76037623sp_ies
spiffed16257103sp_iffed
spik105419713sp_i_k
spike114922843sp_ike
spiks114117473sp_iks
spiky146014113sp_iky
spile75230083sp_ile
spiled94621993spiled
spiles84227913spiles
spiling102919703spiling
spill74821163sp_ill
spills84717463spills
spilt75532223sp_ilt
spilth11469733spilth
spin66231303sp_i_n
spine76534423sp_ine
spinoff1544933spinoff
spins75327983sp_ins
spiny104921303sp_iny
spire75828693sp_ire
spirt75032953sp_irt
spiry105017353sp_iry
spit65545083sp_i_t
spite75430663sp_ite
spits74429553sp_its
spitz166017973sp_itz
spiv95917793sp_i_v
spivs105114243sp_ivs
splake1259783splake
splash1168823splash
splat76129343spl_at
splats84817303splats
splay105816043spl_ay
splays114910873splays
spleen8310263spleen
splent84720193splent
spliced124310593spliced
splicer114710523splicer
splices113914383splices
splined105013113splined
splines94718893splines
splints94511743splints
splore81611303splore
splosh1186543splosh
spoil75818653spoi_l
spoils84614533spoils
spoilt85016593spoilt
spoof105019013sp_oof
spoofs114011813spoofs
spoofy14498553spoofy
sprier84119063sprier
sprig85617743spri_g
sprigs94814773sprigs
spring94526013spring
sprint84526793sprint
sprit76736403spri_t
sprite84421773sprite
sprits85122533sprits
spritz174714423spritz
spuing94313363spuing
spying123913253spying
squiffy2542573squiffy
staff113817713s_taff
stiffs12389963s_tiffs
strife95318363strife
stuff113817053s_tuff
sulfa8313923sul_fa
sulfid1039063sulfid
sulfo8313363sul_fo
swift116818053s_wift
syli74318983syli__
sylis84316023syli_s
tariff12711363tariff
tiff104727723__tiff
uglify1333913uglify
uplifts12424773uplifts
uplink12388713uplink
uplit76020803upli_t
vilify1536773vilify
whiff17310063_whiff

Search took 6 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.1231452772.4
2DLD Change Limit1127162175.69019809.5
3Display Results2172170.0603616.7
 (SQL Overall)1786912175.87330425.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.