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

163 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
slices8402285(None) 
saices84221801saices
sices75637271s_ices
slice74925821slice_
sliced94416311sliced
slicer84117601slicer
slicers94114921slicers
slicks124816111slicks
slides73922181slides
slimes84722041slimes
slipes84921411slipes
sluices959071sluices
spices104326031spices
splices113914381splices
alines65735222alines
amices105018012amices
apices104916262apices
bices95029962_bices
blites84721212blites
calices114321692calices
cilices113814022cilices
cliches144213742cliches
clicks145315112clicks
climes104720002climes
clines84926042clines
culices113713122culices
cylices14359282cylices
deices94119372deices
dices86434242_dices
elides74420692elides
elites66027122elites
fices106031162_fices
flicks154512992flicks
flics105418362flic_s
flies85630712fli_es
flites95122442flites
glaces94218022glaces
glides84518862glides
glimes94717522glimes
helices12313722helices
ibices10398162ibices
ices66129642__ices
juices1549422juices
klicks11468722klicks
laces76141762_laces
lice66045062_lice_
liches114724292_liches
licks115325392_licks
lies46454192_li_es
likes96231902_likes
limes75636502_limes
lines57054572_lines
lives86133192_lives
luces75528432_luces
malices114316622malices
olives94313952olives
places104323702places
plaices11411142plaices
plies74526512pli_es
polices113118052polices
prices104524542prices
rices75536152_rices
saice75424052saice_
salines74029412salines
sauces84919502sauces
scolices1238732scolices
seiches12513812seiches
seines65029902seines
seises64026712seises
seizes154317532seizes
shies86136552shi_es
shines95028912shines
shires95225572shires
shives124921412shives
sice65545592s_ice_
sicks115127622s_icks
sics65234092s_ic_s
sides65838362s_ides
sikes96236082s_ikes
silicas9310602silicas
silicles1037072silicles
sines55954822s_ines
sipes76036952s_ipes
sires55945372s_ires
sises55233832s_ises
sites56045432s_ites
sixes124526362s_ixes
sizes146727762s_izes
skies95026832ski_es
skites104418042skites
skives134113942skives
slacks124416532slacks
slakes104021882slakes
slates64934062slates
slaves95023022slaves
slick115520522slic_k
slicked144413842slicked
slicken13309292slicken
slickens14317262slickens
slicker133314532slicker
slickers143112552slickers
slickest14229252slickest
slide64725412slide_
slider73918362slider
sliders83515222sliders
slier54827242sli_er
sliest66621952sli_est
slieves10378962slieves
slime74925752slime_
slimed94915122slimed
slims75423652sli_ms
slings74618012slings
slinks104315152slinks
slipe75626132slipe_
sliped95417062sliped
slips76023722sli_ps
slits56128852sli_ts
sliver94116592sliver
slivers104115252slivers
sloes54728872sl_oes
slopes84820452slopes
slues54527172sl_ues
sluice849512sluice_
sluiced1046052sluiced
slypes114410482slypes
smiles84522292smiles
smites83921922smites
snicks124312472snicks
snipes83917392snipes
solaces93116132solaces
spaces104722632spaces
spicas104715822spicas
spice95528812spice_
spiced115218312spiced
spicer104719312spicer
spicers113815552spicers
spicey134414232spicey
spicks144814992spicks
spics94123242spic_s
spies76037622spi_es
spikes124520712spikes
spiles84227912spiles
spines85132032spines
spires84628112spires
spites84127332spites
splice104915102splice_
spliced124310592spliced
splicer114710522splicer
splicers12338112splicers
splines94718892splines
stichs114511652stichs
sticks125118612sticks
sties55132982sti_es
stiles64328772stiles
stimes85920572stimes
stipes84524052stipes
suites63727402suites
swipes114114332swipes
swives123915182swives
syces106416462s_yces
trices84826332trices
vices105725532_vices
voices114414012voices

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 Filter178691825510.750238254.7
2DLD Change Limit825511635.62614673.1
3Display Results1631630.0463543.5
 (SQL Overall)1786911636.42227824.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.