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

351 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
troupers1035942(None) 
groupers11358631groupers
troopers10289421troopers
trouper93811411trouper_
troupes94112841troupe_s
trousers83910621trousers
arousers84810972arousers
croppers143311482croppers
croupes114613102croupe_s
croupiers1334632croupiers
droppers13318592droppers
gropers104813852gro_pers
grouper104210092grouper_
grousers93810722grousers
grouters95910062grouters
propers113619032pro_pers
prospers123012252prospers
rompers113412242_rompers
ropers84325902_ro_pers
rousers75220132_rousers
routers74822852_routers
stroppers1356702stroppers
topers85025322t_o_pers
toppers113914602t_oppers
toupees938512t_oupees
tourers73512732t_ourers
touters74018332t_outers
trampers123210372trampers
trappers123711022trappers
trippers123210152trippers
troffers14125422troffers
trollers83211202trollers
trompes114111622trompe_s
trooper94210352trooper_
tropes84824352tro_pe_s
trotters83310232trotters
troublers1134982troublers
trouncers1134792trouncers
troupe84812432troupe__
trouped103910972troupe_d
trouser73812462trouser_
trouvere1144052trouvere
trouveres1243762trouveres
trouveurs1241632trouveurs
trovers103713312tro_vers
trowsers11427982trowsers
arguers8489023argu_ers
armourers1154063armourers
arouser74514423arouser_
arouses74921293arouse_s
bloopers12397373bloopers
boppers133911923_boppers
broiders114211183broiders
broilers103210093broilers
brokers133111913bro_kers
bronzers19296983bronzers
brooders112610233brooders
brothers133410823brothers
browsers13449193browsers
carousers1156733carousers
chompers17369573chompers
choppers174110453choppers
chousers134610183chousers
clouters10399793clouters
coopers114019483_coopers
copers104629843_co_pers
coppers133519753_coppers
corulers1039763corulers
coupes105022523_coupe_s
couplers123311313_couplers
couters93827283_couters
crappers144011023crappers
creepers12318623creepers
crimpers14318933crimpers
crispers12309433crispers
croakers14288503croakers
crofters13358893crofters
crooners103911393crooners
cropper133312963cropper_
crosiers103312053crosiers
crossers103912693crossers
croupe105114433croupe__
croupier1246883croupier_
croupous1245903croupous
croups104312553croup__s
croutes94815643croute_s
crowders14398793crowders
crowers124614893cro_wers
crowners133710743crowners
crozers184111083cro_zers
croziers19287003croziers
cruppers14317313cruppers
dopers95522483_do_pers
dorpers104113163_dorpers
dousers84817273_dousers
drapers105313353dr_apers
drippers13327933drippers
droners84114383dro_ners
dropper12329873dropper_
drovers115212643dro_vers
drowners12428273drowners
drupes94912653dr_upe_s
dupers94615603__dupers
elopers95112943elo_pers
floppers15337463floppers
flouters11419263flouters
frothers14279803frothers
frowners14377933frowners
gougers94911763_gougers
graspers11338393graspers
graupels1133103graupels
gripers104011463gr_ipers
grippers13358123grippers
groaners9248493groaners
grocers103511253gro_cers
groomers11388483groomers
groovers12337123groovers
groper94517253gro_per_
gropes95220403gro_pe_s
grossers94410973grossers
grounders1156773grounders
grouped11419193groupe_d
groupies1137523groupies
groups94210513group__s
grouser84513693grouser_
grouses84616543grouse_s
grouter84412523grouter_
growers113612723gro_wers
growlers12327093growlers
hoopers123616483_hoopers
hopers114222973_ho_pers
hoppers143115143_hoppers
housers104717813_housers
ironers74813543iro_ners
kreuzers2132063kreuzers
larrupers1142523larrupers
loopers93914033_loopers
lopers84424143_lo_pers
loppers113014103_loppers
loupes84918053_loupe_s
louvers10359103_louvers
mopers104220373_mo_pers
moppers133412453_moppers
mousers95216443_mousers
outers64230163__outers
paupers114311073_paupers
poppers103414863_poppers
pourers93513673_pourers
pouters94221863_pouters
probers113514573pro_bers
procurers1345033procurers
prodders1237453prodders
producers1454883producers
proffers16126593proffers
proggers12258163proggers
prompters1537533prompters
proofers13118363proofers
propels113412843pro_pels
proper104319953pro_per_
prosers94219643pro_sers
prosper114012183prosper_
prouder10310373prouder_
provers123817793pro_vers
prowlers13328933prowlers
pruners93710723pr_uners
rapers84327183_r_apers
rappers113618443_rappers
raspers94415913_raspers
reapers93520453_reapers
rippers114115023_rippers
roamers93713453_roamers
roarers73812733_roarers
robbers112814153_robbers
rockers133916553_rockers
rogers74517913_ro_gers
rolfers104011813_rolfers
rollers73117473_rollers
romper104213683_romper_
roofers105013903_roofers
roomers95416413_roomers
roosers74217873_roosers
rooters74522933_rooters
roper75431913_ro_per_
ropery114313873_ro_pery
ropes75940063_ro_pe_s
rosters73727533_rosters
rotters74421393_rotters
rouens64814443_rou_ens
roues56039353_rou_e_s
rouges76022383_rouge_s
roughers12329173_roughers
rounders92613683_rounders
rouped95717353_roupe_d
roupet84218343_roupe_t
roupier9319493_roupier_
roups75118903_roup__s
rouser65224083_rouser_
rouses65436283_rouse_s
rousters84315653_rousters
router65025843_router_
routes66129313_route_s
rovers95423523_ro_vers
rowers94924573_ro_wers
rozzers1535633_rozzers
ruers515019413_r_u_ers
rulers64317093_r_ulers
rupees8312573_r_upees
scaupers12378173scaupers
scoopers124210193scoopers
scourers10348533scourers
scouters103411303scouters
shoppers153010753shoppers
shouters113510593shouters
slopers94213093slo_pers
snoopers10319833snoopers
soapers93715923_soapers
souters74422583_souters
spouters104011143spouters
stompers123610033stompers
stoopers103711293stoopers
stopers94217363sto_pers
stoppers123910573stoppers
strappers1346733strappers
stripers103911583str_ipers
strippers1355753strippers
strokers123910893stro_kers
strollers937523strollers
stropper1247753stropper_
stroyers11388913stro_yers
supers84622403__supers
swoopers13317523swoopers
tabourers1144673tabourers
tampers113516743t_ampers
tapers84025813t__apers
tappers113416543t_appers
tarpapers1344273tarpapers
taupes8212673t_aupe_s
tempers113513013t_empers
thorpes125010353thorpe_s
threapers1444773threapers
throbbers1643153throbbers
throwers14106023thro_wers
thumpers15365713thumpers
tippers113414343t_ippers
tochers123413093t_ochers
toilers74116263t_oilers
tokers104818893t_o_kers
tollers73217453t_ollers
toners64128003t_o_ners
tongers84116013t_ongers
tonners73816403t_onners
toolers74416503t_oolers
tooters73818773t_ooters
tootlers8289503tootlers
topees85519703t_o_pees
toper75231023t_o_per_
topes76941763t_o_pe_s
topper103817603t_opper_
torpors939373t_orpors
torquers17204303torquers
torturers944343torturers
tossers74713493t_ossers
toters65026363t_o_ters
totters74618733t_otters
touchers133611203t_ouchers
toupee8316133t_oupe_e
tourer64115073t_ourer_
tours55325863t_ou__rs
touses64229673t_ouse_s
touter63821033t_outer_
towers94423673t_o_wers
toyers95516333t_o_yers
tracers94917833tr_acers
trackers143512843trackers
traders84316943tr_aders
traducers1243713traducers
trailers82912913trailers
trainers83114633trainers
tramper113812153tramper_
tramplers13305873tramplers
trapes85024463tr_ape_s
trapper113912793trapper_
trashers113013623trashers
trawlers113310193trawlers
treaders93311833treaders
treaters83615823treaters
trekkers1133803trekkers
trickers143812813trickers
triers64321523tr__iers
triflers113110213triflers
triggers10257843triggers
trillers83613483trillers
trimers94615143tr_imers
trimmers12288913trimmers
tripes85324873tr_ipe_s
tripper113711923tripper_
trippets12357423trippets
triunes74311383triune_s
trocars959023tro_cars
trochars1377843trochars
trochees132510183trochees
troches123715343troche_s
troffer13125863troffer_
trokes104019263tro_ke_s
troller73913173troller_
trolleys11315693trolleys
trommels12254333trommels
trompe105611263trompe__
tromped124210293trompe_d
tromps104911703tromp__s
trones65629283tro_ne_s
trooped104010723troope_d
troops85712773troop__s
trope75725803tro_pe__
tropics113610643tro_pics
tropins93116303tro_pins
trotter73312253trotter_
troubler1035283troubler_
troubles1057183troubles
troughs11698673trou_ghs
trouncer1035433trouncer_
trounces1037053trounces
troupial1044183troupial
troupials1142923troupials
trouping11249503trouping
troutier8277143troutier_
trouts66116623trou__ts
trouveur1141663trouveur
trover95014663tro_ver_
troves94719113tro_ve_s
trowelers12105253trowelers
trowels10358363tro_wels
truces84916333tr_uce_s
truckers14279003truckers
trudgers10256853trudgers
truer54916643tr_u_er_
trues54925323tr_u_e_s
trumpery1533613trumpery
trumpets12315573trumpets
trussers8348263trussers
trusters83112243trusters
trysters11298363trysters
tubers85017023t__ubers
tuners64417343t__uners
tuyers94612563t__uyers
twofers1364053two_fers
whoopers16286263whoopers
whoppers18297533whoppers
wrappers15306933wrappers
wrongers12327773wrongers
yaupers12337663_yaupers

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.1701051123.5
2DLD Change Limit1461623516.94021060.8
3Display Results3513510.1402507.1
 (SQL Overall)1786913517.25024647.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.