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

101 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
sniped9491348(None) 
siped84927681s_iped
sliped95417061sliped
snipe75320571snipe_
sniper84413641sniper
snipes83917391snipes
snipped123510041snipped
stiped94517071stiped
swiped123811091swiped
aliped95414282aliped
biped104718832_biped
griped104114712griped
knifed14528122knifed
nided75920872_nided
nipped113615852_nipped
nixed135714222_nixed
piped105123162_piped
riped85226432_riped
sailed74327762sailed
sained75424242sained
sapped114422012sapped
scaped115519552scaped
scoped115116652scoped
seeped94317522seeped
seined74023062seined
seised74218122seised
seized164313652seized
shaped125020102shaped
shied96125492shi_ed
shined104620782shined
shipped153312102shipped
sided74825952s_ided
singed85422292singed
sinned73818412sinned
sipe67341042s_ipe_
sipes76036952s_ipes
sipped113720632sipped
sired66134282s_ired
sited65130742s_ited
sized155519242s_ized
skied104417752ski_ed
skimped16256222skimped
skipped16358402skipped
skited114313472skited
skived14429892skived
sliced94416312sliced
slimed94915122slimed
slipe75626132slipe_
slipes84921412slipes
slipped124711742slipped
sloped94216852sloped
smiled93716432smiled
snailed83811922snailed
snaked115017592snaked
snapped124611202snapped
snared74824552snared
snawed104813732snawed
sneaped10338812sneaped
sned56026052sn__ed
snibbed12325632snibbed
snicked143811632snicked
snide64318722snide_
snider74413912snider
sniffed14318182sniffed
snip66424652snip__
snipers93311762snipers
snipper113911322snipper
snippet113310432snippet
snippy1374842snippy
snips75818012snip_s
snivel9368852snivel
snooped103711812snooped
snored74819542snored
snowed104613612snowed
soaped95817972soaped
soiled73822472soiled
sopped114819902sopped
souped95017672souped
sped76031492s__ped
spiced115218312spiced
spied85427712spi_ed
spiked134915552spiked
spiled94621992spiled
spined95423942spined
spired94921862spired
spited94820442spited
stied65723032sti_ed
stipe76523372stipe_
stipel84412122stipel
stipend10386552stipend
stipes84524052stipes
stoped94721012stoped
striped105214362striped
suited74019422suited
supped114415702supped
swipe105217082swipe_
swipes114114332swipes
swived133610632swived
unipod946852unipod
united74421542united
wiped114722082_wiped

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.186960704.3
2DLD Change Limit825511012.26636430.3
3Display Results1011010.0333060.6
 (SQL Overall)1786911012.48571907.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.