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

105 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
stopers9421737(None) 
slopers94213091slopers
stokers114515181stokers
stompers123610041stompers
stoners74817951stoners
stoopers103711301stoopers
stoper84320101stoper_
stopes84525891stope_s
stoppers123910591stoppers
storers75018681storers
stovers103713731stovers
topers85025321_topers
atoners75013952atoners
coopers114019482coopers
copers104629842_copers
dopers95522482_dopers
elopers95112942elopers
estovers1136452estovers
gropers104813852gropers
hoopers123616492hoopers
hopers114222972_hopers
loopers93914032loopers
lopers84424142_lopers
mopers104220372_mopers
propers113619032propers
ropers84325902_ropers
sappers113518902sappers
scoopers124210192scoopers
scopes104719592scope_s
scorers94115322scorers
scoters93313812scoters
shapers124016892shapers
shoers94518332sho_ers
shoppers153010762shoppers
shovers134613002shovers
showers134612682showers
simpers113014122simpers
sippers113117752sippers
sloper84615912sloper_
slopes84820452slope_s
smokers13389322smokers
snipers93311772snipers
snoopers10319842snoopers
snorers74313802snorers
soapers93715922soapers
sobers85218862s_obers
sooners73916642sooners
sopors85215202s_opors
sowers94923442s_owers
stagers84116672stagers
stampers124211602stampers
stapes85028732stape_s
staplers103111202staplers
starers74522312starers
staters73922342staters
stayers103813632stayers
steepers103011372steepers
steers63820982st_eers
steppers12289282steppers
stipels9418952stipels
stipes84524052stipe_s
stivers103613542stivers
stockers143411072stockers
stogeys11486122stogeys
stoker104417622stoker_
stokes104821792stoke_s
stoles63927672stole_s
stomper114111232stomper_
stoner65823202stoner_
stones65130032stone_s
stookers12449792stookers
stooper93813192stooper_
stope74727242stope__
stoped94721012stope_d
stopovers1443832stopovers
stopper113012602stopper_
stops74827282stop__s
storer64721672storer_
stores65533662store_s
storeys10559652storeys
stoures74614162stoures
stours65015632sto_urs
stover94115642stover_
stoves93818922stove_s
stripers103911592stripers
strokers123910902strokers
stroppers1356712stroppers
stroyers11388922stroyers
stumpers12318312stumpers
stupes84116952stupe_s
stupors935882stupors
stylers10359352stylers
supers84622402s_upers
suppers113314702suppers
swoopers13317522swoopers
tapers84025812_tapers
tokers104818892_tokers
toners64128002_toners
topees85519702_topees
toper75231022_toper_
topes76941762_tope_s
toppers113914602_toppers
toters65026362_toters
towers94423672_towers
toyers95516332_toyers

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 Limit1076711053.50030763.1
3Display Results1051050.0303500.0
 (SQL Overall)1786911053.90645747.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.