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

138 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
stiped9451707(None) 
siped84927681s_iped
sliped95417061sliped
sniped94913481sniped
stied65723031sti_ed
stipe76523371stipe_
stipel84412121stipel
stipend10386551stipend
stipes84524051stipes
stoped94721011stoped
striped105214361striped
swiped123811091swiped
aliped95414282aliped
biped104718832_biped
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
staged84521562staged
stained84215342stained
staked114621942staked
staled74728102staled
stamped124812812stamped
staned74824642staned
stapes85028732stapes
stapled103613702stapled
stared75429872stared
stated75427832stated
staved103918052staved
stayed104817272stayed
steed66024942st_eed
steeped103412282steeped
stepped123210052stepped
stewed104814242stewed
sticked144114632sticked
sties55132982sti_es
stiffed14359582stiffed
stifled113511092stifled
stile54931572stile_
stiles64328772stiles
stilled83314792stilled
stilted83511472stilted
stime76521802stime_
stimes85920572stimes
stimied10310622stimied
stinted82914192stinted
stipels9418952stipels
stipends11304792stipends
stippled1345302stippled
stipuled1134452stipuled
stirpes95011292stirpes
stirred8359702stirred
stiver93915732stiver
stoked114718292stoked
stoled74521592stoled
stomped124110532stomped
stoned75923142stoned
stooped103813832stooped
stope74727242stope_
stoper84320102stoper
stopes84525892stopes
stopped124512202stopped
stored75524212stored
stowed105817202stowed
stripe85822442stripe_
striper94514792striper
stripes95320572stripes
stripped1357092stripped
strived114713662strived
stumped124210152stumped
stupe75217752stupe_
stupes84116952stupes
stupid937592stupid
styed95815482st_yed
styled105613102styled
suited74019422suited
supped114415702supped
swipe105217082swipe_
swipes114114332swipes
swived133610632swived
taped85327422_taped
tided76322512_tided
tied55535212_ti_ed
tiled64832942_tiled
timed85223612_timed
tined65434532_tined
tipped114418262_tipped
tired65228902_tired
toped85631312_toped
typed115815452_typed
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.346516448.0
2DLD Change Limit825511382.53032628.9
3Display Results1381380.0463000.0
 (SQL Overall)1786911382.92261153.7
 
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.