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

153 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
spliffs153356(None) 
spiffs14328471sp_iffs
spliff1438601spliff_
cliffs14477592_cliffs
gliffs13436322_gliffs
sclaffs1543572sclaffs
skiffs16327012s_kiffs
sluffs12349582s_luffs
sniffs12378842s_niffs
spiff133616402sp_iff_
spiffy17326222sp_iffy
splices113914382splices
splines94718892splines
splints94511742splints
splits85416412spli_ts
stiffs12389962s_tiffs
uplifts12424772uplifts
alifs86121263_ali_fs
aplites9314933aplites
bailiffs1642563bailiffs
beliefs12448583beliefs
biffs134814413__biffs
blaffs14426623_blaffs
bluffs14388373_bluffs
califs114915893cali_fs
cliff135917133_cliff_
cliffy17435243_cliffy
clifts11519153_clifts
diffs126315483__diffs
fluffs11347783_fluffs
gliff124915663_gliff_
goniffs14473903goniffs
griffs13398993_griffs
jiffs185710313__jiffs
kalifs134410983kali_fs
lifts85719063__lifts
luffs114516283__luffs
miffs134512883__miffs
pilaffs15365153pilaffs
pilafs113511023_pilafs
pliers84715153_pliers
plies74526513_pli_es
plinks124913263_plinks
pouffs14418123_pouffs
puffs134114933_p_uffs
quiffs21135433_quiffs
reliefs10439433reliefs
riffs115114613__riffs
salifies11314793salifies
salify12311373sali_fy
salinas73116093salinas
salines74029413salines
salivas10309603salivas
saplings11269803saplings
sclaff1438313sclaff_
scoffs14347503s_coffs
scruffs1554173scruffs
scuffs14419053s_cuffs
sealifts1135473sealifts
seifs85019333s_ei_fs
selfs85220243sel__fs
selloffs1443633selloffs
serifs94017053seri_fs
setoffs1334133setoffs
sheriffs17253923sheriffs
shifts124412943s_hifts
shoplifts1742763shoplifts
shrifts1335963shrifts
shroffs1634363shroffs
sifts84918923s__ifts
silicas9310603silicas
skiff153612803s_kiff_
slices84022853s_lices
slicks124816113s_licks
slides73922183s_lides
slimes84722043s_limes
slims75423653s_li_ms
slings74618013s_lings
slinks104315153s_links
slipes84921413s_lipes
slips76023723s_li_ps
slits56128853s_li_ts
sluff114016813s_luff_
sniff113915863s_niff_
sniffy15337193s_niffy
snuffs12358533s_nuffs
solids74116403soli_ds
solidus8338113solidus
solions7513753solions
spails84817823spai_ls
spaits85017473spai_ts
speils84116223spei_ls
speirs85013233spei_rs
speises93813933speises
speiss84311643spei_ss
spicas104715823sp_icas
spices104326033sp_ices
spicks144814993sp_icks
spics94123243sp_i_cs
spiels85317953sp_iels
spiers84421743sp_iers
spies76037623sp_i_es
spiffed16257103sp_iffed
spiffies16277993sp_iffies
spikes124520713sp_ikes
spiks114117473sp_i_ks
spiles84227913sp_iles
spilings11308813spilings
spills84717463sp_ills
spilths12356023spilths
spines85132033sp_ines
spinoffs1642773spinoffs
spins75327983sp_i_ns
spires84628113sp_ires
spirts85317133sp_irts
spites84127333sp_ites
spits74429553sp_i_ts
spivs105114243sp_i_vs
splakes1349673splakes
splats84817303spl_ats
splays114910873spl_ays
spleens937103spleens
splents93912133splents
splice104915103spli_ce
spliced124310593spliced
splicer114710523splicer
splicers12338113splicers
spline86020533spli_ne
splined105013113splined
splint85223283spli_nt
split75729013spli__t
splores91910953splores
spoils84614533spoi_ls
spoofs114011813sp_oofs
sprigs94814773spri_gs
springs104415923springs
sprints94113773sprints
sprites94220333sprites
sprits85122533spri_ts
squiffy2542573squiffy
staffs12349753s_taffs
stiff114219243s_tiff_
strifes104716583strifes
stuffs123810223s_tuffs
sulfas9311563sul_fas
sulfids1137293sulfids
swifts12408173s_wifts
sylis84316023syli__s
tariffs1334593tariffs
tiffs114414883__tiffs
uplift114610653upli_ft
uplinks13345613uplinks
whiffs1835083_whiffs

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.403443402.0
2DLD Change Limit1340271536.12621878.4
3Display Results1531530.0463326.1
 (SQL Overall)1786911536.57527177.3
 
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.