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 “stooped” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
stooped10381383(None) 
scooped124611751scooped
snooped103711811snooped
stomped124110531stomped
stooged94310731stooged
stooked124312301stooked
stooled84313891stooled
stooper93813191stooper
stoped94721011st_oped
stopped124512201stopped
swooped13418751swooped
blooped12398542blooped
cooped114821612_cooped
drooped11368432drooped
estopped1335002estopped
hooped125518182_hooped
looped95217172_looped
pooped113915942_pooped
scooper113812032scooper
scooted103612282scooted
scoped115116662s_coped
scrooped1356412scrooped
shooed103916082shoo_ed
shooled115212662shooled
shopped153512212shopped
sloped94216852s_loped
slopped123511442slopped
snooded94110362snooded
snooked123711492snooked
snooled84513942snooled
snooper93511532snooper
snooted84213282snooted
snoozed173410132snoozed
soaped95817972s_oaped
sooted73922592s_ooted
sopped114819902s_opped
souped95017672s_ouped
spoofed13399102spoofed
spooked144510472spooked
spooled104613522spooled
spooned103412442spooned
spoored104411292spoored
stamped124812812stamped
steeped103412282steeped
stepped123210052stepped
stiped94517072st_iped
stobbed12287492stobbed
stocked144312872stocked
stodged10377982stodged
stoked114718292st_oked
stoled74521592st_oled
stomper114111232stomper
stoned75923142st_oned
stood65517712stoo__d
stooge73811662stooge_
stooges83611482stooges
stooker113811732stooker
stoop75821542stoop__
stoopers103711302stoopers
stoops85917892stoop_s
stope74727242st_ope_
stoper84320102st_oper
stopes84525892st_opes
stopper113012602stopper
stoppled1345002stoppled
stored75524212st_ored
storied8515162storied
stormed1039042stormed
stotted83511422stotted
stowed105817202st_owed
striped105214362striped
stroked124613622stroked
stropped1367352stropped
strowed115312142strowed
stroyed114110862stroyed
stumped124210152stumped
swooned11368592swooned
swooper12389172swooper
swopped15437672swopped
tooled74918902_tooled
tooted74620122_tooted
toped85631312_t_oped
topped114617722_topped
trooped104010722trooped
whooped16326932whooped

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 Filter1786911076710.376475242.0
2DLD Change Limit107671852.95336461.6
3Display Results85850.0165312.5
 (SQL Overall)178691853.34553420.3
 
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.