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

209 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
stropper124776(None) 
stopper113012601st_opper
strapper1258091strapper
stripper1247121stripper
stropped1367341stropped
stroppers1356711stroppers
stroppier1364451stroppier
cropper133312962_cropper
dropper12329872_dropper
scrapper1466972scrapper
shopper143312632s_hopper
stepper113010852st_epper
stomper114111232st_omper
stooper93813192st_ooper
stoper84320102st_o_per
stopped124512202st_opped
stoppers123910592st_oppers
strapped1357822strapped
strappers1346742strappers
strappier1345132strappier
striper94514792str_iper
stripier1058862stripier
stripped1357092stripped
strippers1355772strippers
stroker114113522stro_ker
stroller848182stroller
stronger9349692stronger
strophe1239142strophe_
strophes13310602strophes
stroppy14205092stropp_y
stroyer103510782stro_yer
topper103817602_t_opper
trapper113912802_trapper
tripper113711922_tripper
trooper94210362_trooper
trouper93811432_trouper
bebopper1642103bebopper
bopper123813833__bopper
cartopper1543743cartopper
chopper163611893_chopper
copper124321893__copper
crapper133913193_crapper
cropped143812063_cropped
croppers143311483_croppers
crupper13338563_crupper
dripper12349233_dripper
dropped13329283_dropped
droppers13318603_droppers
entrapper1344853entrapper
estopped1334993est_opped
estoppel1243173est_oppel
flopper14328473_flopper
gripper124410713_gripper
groper94517253_gro_per
grouper104210093_grouper
hopper134218483__hopper
lopper103717203__lopper
mopper126215003__mopper
popper93615963__popper
proper104319953_pro_per
propped113311953_propped
prosper114012193_prosper
rapper104621573__rapper
ripper103518653__ripper
romper104213683__romper
roper75431913__ro_per
ropier84118803__ropier
sapper103822353s__apper
scooper113812033s_cooper
scraper114513423scr_aper
scrapped1556533scrapped
scrappers1545863scrappers
scrappier1544423scrappier
scrimper1455763scrimper
scripter12137783scripter
scrooped1356403scrooped
scupper1367423s_cupper
shipper143514043s_hipper
shoppe133110323s_hoppe_
shopped153512213s_hopped
shoppers153010763s_hoppers
shoppes143411393s_hoppes
shrimper1544413shrimper
sipper103920993s__ipper
sirupier1034303sirupier
skipper15339573s_kipper
slapper113512463s_lapper
slipper113712983s_lipper
sloper84615913s_lo_per
slopped123511443s_lopped
sloppier1255703s_loppier
snapper113512073s_napper
snipper113911333s_nipper
snooper93511533s_nooper
snoopier10177273snoopier
soaper84517873s__oaper
sopped114819903s__opped
soppier112711583s__oppier
stamper113714403st_amper
stapler93913633st_apler
steeper93812773st_eeper
steppe10319873st_eppe_
stepped123210053st_epped
steppers12289283st_eppers
steppes113110693st_eppes
stippler1235543stippler
stocker133713083st_ocker
stoker104417623st_o_ker
stomped124110533st_omped
stompers123610043st_ompers
stoner65823203st_o_ner
stonier72013793st_onier
stooker113811733st_ooker
stooped103813833st_ooped
stoopers103711303st_oopers
stope74727243st_o_pe_
stoped94721013st_o_ped
stopers94217373st_o_pers
stopes84525893st_o_pes
stopover1344063st_opover
stoppered1444473st_oppered
stopple1156583st_opple
stoppled1345003st_oppled
stopples1236953st_opples
storer64721673st_o_rer
stormier1036103stormier
stouter74012053st_outer
stover94115643st_o_ver
strafer103912463str_afer
strainer8512223strainer
straiter8311783straiter
strander97112063strander
stranger94715103stranger
strappy14205263strapp_y
strawier1137493strawier
strayer104312503str_ayer
streaker12229483streaker
streamer10239513streamer
streeker12206643streeker
strewer104310413str_ewer
stricter1039423stricter
strider84315723str_ider
striker113714173str_iker
stringer93812943stringer
stripe85822443str_ipe_
striped105214363str_iped
stripers103911593str_ipers
stripes95320573str_ipes
striver104315203str_iver
strobe84513813stro_be_
strobes93813263stro_bes
strode75215973stro_de_
stroke105116173stro_ke_
stroked124613623stro_ked
strokers123910903stro_kers
strokes114316323stro_kes
strolled937823strolled
strollers937553strollers
strop77422243stro_p__
strophic1569003strophic
stroppiest1444563stroppiest
stropping1436933stropping
strops86220383stro_p_s
strove95014793stro_ve_
strowed115312143stro_wed
stroyed114110863stro_yed
stroyers11388923stro_yers
strummer1234783strummer
strumpet1256033strumpet
strutter846503strutter
stumper113610093st_umper
stumpier1255883stumpier
supper104115433s__upper
swapper14359703s_wapper
swooper12389173s_wooper
swoopier13175143swoopier
swopped15437673s_wopped
syrupier1343053syrupier
tapper104419613_t_apper
tipper103918413_t_ipper
toper75231023_t_o_per
topped114617723_t_opped
toppers113914603_t_oppers
tramper113812163_tramper
trapped124512213_trapped
trappers123711043_trappers
tripped123911693_tripped
trippers123210163_trippers
trippet113714113_trippet
trippier1246623_trippier
troffer13125863_troffer
troller73913173_troller
trompe105611263_trompe_
tromped124210293_tromped
trompes114111623_trompes
trooped104010723_trooped
troopers10289443_troopers
trope75725803_tro_pe_
tropes84824353_tro_pes
trotter73312253_trotter
troupe84812433_troupe_
trouped103910983_trouped
troupers10359443_troupers
troupes94112853_troupes
trouser73812473_trouser
trover95014663_tro_ver
unstopper1343523unst_opper
whopper17328503_whopper
wrapper14368333_wrapper

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622096.87621256.8
3Display Results2092090.0762750.0
 (SQL Overall)1786912097.37524229.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.