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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

154 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
stroppers135672(None) 
stoppers123910591st_oppers
strappers1346741strappers
strippers1355771strippers
stropper1247761stropper_
croppers143311482_croppers
droppers13318602_droppers
scrappers1545862scrappers
shoppers153010762s_hoppers
steppers12289282st_eppers
stompers123610042st_ompers
stoopers103711302st_oopers
stopers94217372st_o_pers
stopper113012602st_opper_
strapper1258092strapper_
stripers103911592str_ipers
stripper1247122stripper_
strokers123910912stro_kers
strollers937562strollers
strophes13310602strophe_s
stropped1367352stroppe_d
stroppier1364462stroppier_
stroyers11388932stro_yers
toppers113914602_t_oppers
trappers123711042_trappers
trippers123210162_trippers
troopers10289442_troopers
troupers10359442_troupers
beboppers1742323beboppers
boppers133911923__boppers
cartoppers1643753cartoppers
choppers174110463_choppers
coppers133519753__coppers
crappers144011023_crappers
cropper133312973_cropper_
cruppers14317323_cruppers
drippers13327943_drippers
dropper12329873_dropper_
entrappers1444183entrappers
estoppels1342353est_oppels
floppers15337463_floppers
grippers13358133_grippers
gropers104813853_gro_pers
groupers11358643_groupers
hoppers143115143__hoppers
loppers113014103__loppers
moppers133412463__moppers
poppers103414863__poppers
propers113619033_pro_pers
prospers123012263_prospers
rappers113618443__rappers
rippers114115033__rippers
rompers113412243__rompers
ropers84325903__ro_pers
sappers113518903s__appers
scoopers124210193s_coopers
scrapers125510533scr_apers
scrapper1466973scrapper_
scrimpers1554643scrimpers
scripters13116683scripters
scuppers1446543s_cuppers
shippers153012313s_hippers
shopper143312633s_hopper_
shoppes143411403s_hoppe_s
shrimpers1633813shrimpers
sippers113117753s__ippers
skippers16318203s_kippers
slappers123710953s_lappers
slippers123711233s_lippers
slopers94213093s_lo_pers
snappers123510173s_nappers
snippers12299723s_nippers
snoopers10319843s_noopers
soapers93715923s__oapers
stampers124211603st_ampers
staplers103111203st_aplers
steepers103011373st_eepers
stepper113010853st_epper_
steppes113110693st_eppe_s
stipplers1334453stipplers
stockers143411073st_ockers
stokers114515183st_o_kers
stomper114111233st_omper_
stoners74817963st_o_ners
stookers12449793st_ookers
stooper93813193st_ooper_
stoper84320103st_o_per_
stopes84525893st_o_pe_s
stopovers1443833st_opovers
stopped124512203st_oppe_d
stoppered1444473st_oppered
stopples1236953st_opples
storers75018683st_o_rers
stovers103713733st_o_vers
strafers11379913str_afers
strainers9510403strainers
stranders10389943stranders
strangers104112173strangers
strapless1135793strapless
strapped1357823strappe_d
strappier1345143strappier_
strayers113510143str_ayers
streakers13218143streakers
streamers11228083streamers
streekers13195813streekers
strewers11409073str_ewers
striders94412123str_iders
strikers123611293str_ikers
stringers104210653stringers
striper94514793str_iper_
stripes95320573str_ipe_s
stripier1058863stripier_
stripped1357093strippe_d
strivers113911843str_ivers
strobes93813263stro_be_s
stroker114113523stro_ker_
strokes114316323stro_ke_s
stroller848183stroller_
stronger9349703stronger_
strophe1239143strophe__
stroppiest1444583stroppiest
stropping1436933stropping
stroppy14205093stropp__y
strops86220383stro_p__s
stroyer103510783stro_yer_
strummers1333693strummers
strumpets1362893strumpets
strutters955703strutters
stumpers12318313st_umpers
suppers113314703s__uppers
swappers15358083s_wappers
swoopers13317523s_woopers
tappers113416543_t_appers
tippers113414353_t_ippers
topers85025323_t_o_pers
topper103817603_t_opper_
trampers123210393_trampers
trapper113912803_trapper_
tripper113711923_tripper_
trippets12357423_trippets
troffers14125433_troffers
trollers83211213_trollers
trompes114111623_trompe_s
trooper94210363_trooper_
tropes84824353_tro_pe_s
trotters83310253_trotters
trouper93811433_trouper_
troupes94112853_troupe_s
trousers83910633_trousers
trovers103713323_tro_vers
trowsers11428003_trowsers
unstoppers1442673unst_oppers
whoppers18297533_whoppers
wrappers15306933_wrappers

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.513348325.5
2DLD Change Limit1486411546.89321564.1
3Display Results1541540.0762026.3
 (SQL Overall)1786911547.48223882.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.