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

170 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
slice7492582(None) 
lice66045061_lice
saice75424051saice
sice65545591s_ice
sliced94416311sliced
slicer84117601slicer
slices84022851slices
slick115520521slick
slide64725411slide
slime74925751slime
slipe75626131slipe
sluice849511sluice
spice95528811spice
splice104915101splice
alike95523962alike
aline57243152aline
alive85722512alive
amice96122862amice
bice86235552_bice
blite76225352blite
cilice103213352cilice
cliche133712452cliche
click135217952click
clime95720892clime
cline76428532cline
deice84320032deice
dice75841892_dice
elide64922642elide
elite56230182elite
fice95737112_fice
flic96223732flic_
flick145017212flick
flics105418362flics
flite85424962flite
glace87420152glace
glide74521592glide
glime85620192glime
ice56737242__ice
juice14311322juice
klick105311432klick
lace66848472_lace
lich96230842_lich
lick106935072_lick
lie38264522_li_e
life75433732_life
like86040842_like
lime66244932_lime
line46965572_line
lipe66839732_lipe
lire47845292_lire
lite47054542_lite
live76540992_live
luce65132572_luce
malice104818482malice
mice87442222_mice
nice65534712_nice
olive84817152olive
pice84641092_pice
place94824612place
plaice10311552plaice
plica9613372plica
plicae10410952plicae
plie65127392pli_e
police102918562police
price93725412price
rice64942912_rice
saices84221802saices
salic73424712salic_
saline65132702saline
sauce75121652sauce
seiche11811832seiche
seine55732872seine
seise54727852seise
seize143819502seize
shine85533092shine
shire84727132shire
shive114423422shive
sic55847872s_ic_
sices75637272s_ices
sick106435572s_ick
sics65234092s_ics
side55444482s_ide
sike87138782s_ike
silica8311242silica
silicle937752silicle
since75024172since
sine46560622s_ine
sipe67341042s_ipe
sire46150412s_ire
site47052412s_ite
size135630962s_ize
skite95120042skite
skive124614112skive
slack115021762slack
slake93724052slake
slate55438282slate
slave84224032slave
slicers94114922slicers
slicked144413842slicked
slicken13309292slicken
slicker133314532slicker
slicks124816112slicks
slid55828982sli_d
slider73918362slider
slides73922182slides
slier54827242slier
slieve9359272slieve
slily85820032slily
slim66631952sli_m
slimed94915122slimed
slimes84722042slimes
slims75423652slims
slimy105417422slimy
sling66028802sling
slink95422912slink
slip67031732sli_p
sliped95417062sliped
slipes84921412slipes
slips76023722slips
slipt76627482slipt
slit46250102sli_t
slits56128852slits
sliver94116592sliver
sloe45534952sl_oe
slope75823562slope
slue45332192sl_ue
sluiced1046052sluiced
sluices959072sluices
sluicy1166482sluicy
slype105112362slype
smile74823912smile
smite75224862smite
snick114416012snick
snide64318722snide
snipe75320572snipe
solace83415822solace
space95325672space
spic85227432spic_
spica94717942spica
spicae104313702spicae
spiced115218312spiced
spicer104719312spicer
spices104326032spices
spicey134414232spicey
spick134519072spick
spics94123242spics
spicy125417712spicy
spike114922842spike
spile75230082spile
spine76534422spine
spire75828692spire
spite75430662spite
spliced124310592spliced
splicer114710522splicer
splices113914382splices
spline86020532spline
stich104117922stich
stick115121562stick
stile54931572stile
stime76521792stime
stipe76523372stipe
suite54829562suite
swine85625302swine
swipe105217082swipe
swive115316192swive
syce95820282s_yce
trice75127492trice
twice104711122twice
vice95732852_vice
voice104915322voice

Search took 4 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 Filter178691538000.1731032896.0
2DLD Change Limit538001703.18616886.4
3Display Results1701700.1101545.5
 (SQL Overall)1786911703.46951510.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.