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

124 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
sliced9441631(None) 
slice74925821slice_
slicer84117601slicer
slices84022851slices
slicked144413841slicked
slimed94915121slimed
sliped95417061sliped
sluiced1046051sluiced
spiced115218311spiced
spliced124310591spliced
alined75221402alined
aliped95414282aliped
cliched153711022cliched
clicked164112452clicked
deiced104214482deiced
diced95824682_diced
elided84814672elided
flicked174610672flicked
flied96519432fli_ed
flited104616582flited
glided94513902glided
glimed105312282glimed
iced78721892__iced
juiced1636512juiced
laced87132642_laced
lice66045062_lice_
licked134621562_licked
lied55838092_li_ed
liked104523812_liked
limed85426802_limed
lined64934642_lined
lived95523722_lived
placed114318002placed
plied85118592pli_ed
policed123212232policed
priced115018882priced
riced85825542_riced
saice75424052saice_
saices84221802saices
sailed74327762sailed
sained75424242sained
sauced93913302sauced
seined74023062seined
seised74218122seised
seized164313652seized
shied96125492shi_ed
shined104620782shined
sicced11489652sicced
sice65545592s_ice_
sices75637272s_ices
sicked134524402s_icked
sided74825952s_ided
silked114314812silked
siloed74615302siloed
silted74020012silted
siped84927682s_iped
sired66134282s_ired
sited65130742s_ited
sized155519242s_ized
skied104417752ski_ed
skited114313482skited
skived14429892skived
slacked143815452slacked
slaked114318272slaked
slated75028312slated
slaved104017042slaved
slayed104716222slayed
sled55334372sl__ed
slewed104815522slewed
slicers94114922slicers
slick115520522slic_k
slicken13309292slicken
slicker133314532slicker
slicks124816112slicks
slid55828982sli__d
slide64725412slide_
slider73918362slider
slides73922182slides
slier54827242sli_er
slime74925752slime_
slimes84722042slimes
slimmed12368472slimmed
slinked123011382slinked
slipe75626132slipe_
slipes84921412slipes
slipped124711742slipped
slitted83513312slitted
sliver94116592sliver
sloped94216852sloped
slowed104617072slowed
slued64220512sl_ued
sluice849512sluice_
sluices959072sluices
smiled93716432smiled
snicked143811632snicked
sniped94913482sniped
soiled73822472soiled
solaced102911062solaced
spaced114517252spaced
spice95528812spice_
spicer104719312spicer
spices104326032spices
spicey134414232spicey
spied85427712spi_ed
spiked134915552spiked
spiled94621992spiled
spined95423942spined
spired94921862spired
spited94820442spited
splice104915102splice_
splicer114710522splicer
splices113914382splices
splined105013112splined
sticked144114632sticked
stied65723032sti_ed
stiped94517072stiped
suited74019422suited
swiped123811092swiped
swived133610632swived
synced12266962synced
triced95518672triced
unsliced1138092unsliced
viced115118182_viced
voiced123910112voiced

Search took 3 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.343520965.0
2DLD Change Limit825511242.42334069.7
3Display Results1241240.0304133.3
 (SQL Overall)1786911242.79663909.5
 
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.