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

104 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
swiped12381109(None) 
siped84927681s_iped
sliped95417061sliped
sniped94913481sniped
stiped94517071stiped
swipe105217081swipe_
swipes114114331swipes
swived133610631swived
wiped114722081_wiped
aliped95414282aliped
biped104718832_biped
dwined114610212dwined
griped104114712griped
piped105123162_piped
riped85226432_riped
sailed74327762sailed
sained75424242sained
sapped114422012sapped
scaped115519552scaped
scoped115116652scoped
seeped94317522seeped
seined74023062seined
seised74218122seised
seized164313652seized
shaped125020102shaped
shied96125492shi_ed
shined104620782shined
shipped153312102shipped
sided74825952s_ided
sipe67341042s_ipe_
sipes76036952s_ipes
sipped113720632sipped
sired66134282s_ired
sited65130742s_ited
sized155519242s_ized
skied104417752ski_ed
skimped16256222skimped
skipped16358412skipped
skited114313482skited
skived14429892skived
sliced94416312sliced
slimed94915122slimed
slipe75626132slipe_
slipes84921412slipes
slipped124711742slipped
sloped94216852sloped
smiled93716432smiled
snipe75320572snipe_
sniper84413642sniper
snipes83917392snipes
snipped123510042snipped
soaped95817972soaped
soiled73822472soiled
sopped114819902sopped
souped95017672souped
sped76031492s__ped
spiced115218312spiced
spied85427712spi_ed
spiked134915552spiked
spiled94621992spiled
spined95423942spined
spired94921862spired
spited94820442spited
stied65723032sti_ed
stipe76523372stipe_
stipel84412122stipel
stipend10386552stipend
stipes84524052stipes
stoped94721012stoped
striped105214362striped
suited74019422suited
supped114415702supped
swaged114212252swaged
swamped15498442swamped
swapped15429142swapped
swayed133510262swayed
swigged13327182swigged
swilled113611832swilled
swine85625302swine_
swinged123810792swinged
swinked15349032swinked
swiple11379232swiple
swiples12339642swiples
swirled11308222swirled
swished14418842swished
swive115316192swive_
swivel12369322swivel
swives123915182swives
swivet123615472swivet
swooped13418752swooped
swopped15437672swopped
twined104413122twined
wifed125117742_wifed
wiled95231552_wiled
wimped144211512_wimped
wined94434182_wined
wipe94830282_wipe_
wiper105421292_wiper
wipes104827082_wipes
wired95327642_wired
wised95123342_wised
wisped123411892_wisped
wited94727142_wited
wived125121502_wived

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.346516448.0
2DLD Change Limit825511042.23336968.7
3Display Results1041040.0462260.9
 (SQL Overall)1786911042.62568072.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.