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

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

87 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
stoppered144447(None) 
choppered1964882choppered
coppered153410542_coppered
loppered13326752_loppered
scuppered1643932scuppered
skippered1843432skippered
slippered1434822slippered
stopped124512202stopp__ed
stopper113012602stopper__
stoppers123910592stopper_s
stoppled1345002stopp_led
unstoppered1651682unstoppered
chippered1945003chippered
compered153414923_compered
coopered133310933_coopered
estopped1334993estopp__ed
kippered17255623_kippered
lappered13288213_lappered
lippered13287953_lippered
peppered1236133_peppered
prospered1446973prospered
scampered1635233scampered
scarpered1435113scarpered
sceptered1444723sceptered
scowdered1643743scowdered
shopped153512213shopp__ed
shopper143312633shopper__
shoppers153010763shopper_s
showered1537013sho_wered
simpered1338253s_impered
slobbered14144223slobbered
slopped123511443slopp__ed
smoldered1343793smoldered
smothered1545683smothered
snookered1443263snookered
sobered102912433s_o_bered
soldered1038153s_oldered
sopped114819903s_opp__ed
speered103614813s__peered
sphered133512313s__phered
spiered104412463s__piered
staggered1244473staggered
stammered1444643stammered
stampeded15343923stampeded
steamered1244913steamered
steepened1244073steepened
steered83615253st__eered
stepped123210053stepp__ed
stepper113010853stepper__
steppers12289283stepper_s
stippled1345303stipp_led
stomped124110533stomp__ed
stomper114111233stomper__
stompers123610043stomper_s
stooped103813833stoop__ed
stooper93813193stooper__
stoopers103711303stooper_s
stoped94721013sto_p__ed
stoper84320103sto_per__
stopers94217373sto_per_s
stoppage1344683stoppage_
stoppages1444693stoppages
stoppering1544613stoppering
stopple1156583stopp_le_
stopples1236953stopp_les
stopword1444503stopwor_d
stored75524213sto___red
storeyed1234643sto_reyed
stoutened1053573stoutened
stropped1367343stropp__ed
stropper1247763stropper__
stroppers1356713stropper_s
stuttered10145763stuttered
supered10316123s__upered
swopped15437673swopp__ed
syphered1755013s_yphered
tampered13279463_tampered
tapered102612933_t_apered
tempered13248223_tempered
tochered1437913_tochered
topped114617723_topp__ed
topper103817603_topper__
toppers113914603_topper_s
toppled12348843_topp_led
tottered9208703_tottered
towered112911403_to_wered
zippered22244823_zippered

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit148641877.53019739.8
3Display Results87870.0332636.4
 (SQL Overall)178691877.98622375.5
 
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.